Summary / Reports (Multiple Columns Calculation Into Different Reports)

I have an expense workbook (Data) with 4 columns (ID, Item, Cost, Date). I would like to create macros that will generate 3 different reports and write to 3 different worksheets.

The first report is sorted and sum up the cost for each item. Please see the worksheet "Item".

The second report is sorted and sum up the cost for each part ID. Please see the worksheet "ID".

The third report is the cost for each month and Year-to-Date cost right next to it. Please see worksheet "Summary".

write the macros for each of these reports assuming that we don't know the number of rows in the "Data" worksheet.