How to importrange row data with query based on a formula?

I'm trying to import specific row data from different sheets using the IMPORTRANGE and QUERY functions.

The main issue I can't resolve is I need criteria for each sheet.

I have a summary sheet. I'd like to change the date in Cell B1 and have each row A5:A fill with the data from the appropriate sheet.

Summary sheet:

Sheet2:

Sheet3:

I've tried using the transpose function to fit the query format. But the query is then only based on one cell.

So, for example, the rows in Sheet start at 201930, but show in the 201928 column in the summary.

Here is an example sheet.

https://docs.google.com/spreadsheets/d/1thBOsfmzd0wy3-LVLs0Un9WHb-9gVEwTZaGb7FcPqgg/edit?usp=sharing