This is an excel question and Im going to try to explain my issue in as much detail as possible.

I have a folder called finance cards that contains many excel workbooks for each month of the year. When you go into one of those workbooks it gives you values for certain expenses for whatever week you are in. I also have this workbook called Project Estimates. This project estimates workbook has a drop down menu where you can select the month and week number you are in. What i want to happen is when I select say October, week 2, then it pulls that data from that workbook which is in the finance scorecards folder. Each months scorecard is saved as a different workbook, so Id like to be able to maybe use an if statement to pull from all of them if I could, Im not sure. Any help is appreciated.