Goal:

By entering a beginning date and an ending date on Sheet2, I hope to
populate Sheet2 with data from Sheet1 within the selected date range below
row 3 on Sheet2 and above a row of formulas to calculate column totals.

Setup:

Sheet1 €“
€¢ A5:A1058 has a list of dates in ascending order
€¢ Columns B thru E have the dates respective total sales in dollars for
each inventory item (e.g. B = Bottled Beer, C = Draft Beer, D = Liquor, and E
= Wine/Champagne).

Sheet2 €“
€¢ Designed as a printable report.
€¢ Cell B2 = Beginning Report Date and D2 = Ending Report Date
€¢ Cells B5:E5 are waiting for data to be copied down in row 4 to total (i.e.
the formulas move just below the populated cells to give the column totals
for the inserted data.

I have tried a few suggestions from similar posts. However, none quite work
the way I need it to.