Hello, I have a worksheet that tracks income and expenses. I have calculations at the top of the page for different income streams, so where the income/expenses are added are not under typical column headers at the top of the ws, lets call this ws "financials 2022". instead the headers are down around row 17. the data begins on row 19, column A to column O (this should not change in the future). What I want to do is: on a separate ws (lets call it "reports", run a "report". so either monthly or year end. after year end, financials 2022 will be archived and a new sheet "financials 2023" would be created. so for monthly, STEP 1: I would like to have some text boxes on the "reports" tab where i can select the sheet to pull the data from (options being "financials 2021", "financials 2022", etc) Q: can i have the worksheets with "financials" in the name be loaded into a dropdown via query? (there are other worksheets in the workbook with other names) i could do a table but then someone would have to update it. STEP 2 select a month. STEP 3: Hit a button that goes to the "financials" ws and looks for all entries in that date range and pulls it to the "reports" ws. Next for year end, similar to monthly, but select the "financials" sheet and it pulls add data?