Filter from data across numerous sheets in googlesheets

[TheSubject]

Hi All,

I had some great help with a sheets file for logging petty cash receipts for the bar I manage, in which I have a page per month and log various data from receipts for purchases.

I'm now building a "Front Sheet" for it and realised it would be very helpful if I could have a weekly view, with a drop down data validation to select weeks by week number, e.g. week 1, week 2.

I was planning on using the Filter function but can't seem to work out how to make it view data from multiple sheets. There's 12 sheets to look through, jan-dec, but obviously week 1 will be in Jan, week 50 in December and of course some weeks straddle months. The layout of the 12 sheets are identical, everything is dated and I have added a column that returns the weeknumber in column I from the date in column A.

Is there a way to make a filter function on the 13th sheet look across all 12 to give me all the data in a given week, regardless of the month that week falls in?

Thank you all for any help you can give me