Create a Dropdown menu that can return weekly subtotals from specific ranges

[riceguy]

Assuming this will require a macro...

I am building a weekly performance workbook that I'm trying to include functionality that can generate/display a weekly summary of key values based on a dropdown selection of a specific week (range).

Attached below is the workbook and the worksheets of interest are labeled "YTD L3 Weeks" and "Weekly Asset Summary".

Ideally, a specific week can be selected in cell "C5" (YTD L3 Weeks) that will display calculated values in rows 3, 5, 7, 8, and 9.

The range of data for eachweek in the worksheet would repeat every 22 rows (21 rows for 7 days x 3 shifts and 1 for the Weekly total)

In turn, these weekly values would link and display on a summary worksheet on "Weekly Asset Summary"

Any recommendations where to start?

Thanks.