Copying values from known worksheet, but unknown workbook, and pasting to current workbook/sheet

[hockdrew]

Basically I have an overview document that compares several different sets of scenarios. Let's call this Overview.xlsm. I have many many scenario results with various names. Each of these scenario workbooks is formatted the exact same and was populated from a standard template. Let's just say they all have sheet1, sheet2 and sheet3. My Overview.xlsm file can compare up to 5 scenarios, and there for there are 5 versions of each comparable sheet (sheet1_scenario1, sheet1_scenario2, ..., sheet3_scenario5.) making 15 different sheets total. What I am trying to do is create 5 different buttons, each assigned to scenarios, to import the data from the selected scenario results workbook. So the first button would be called "import scenario1 results" I would then select the desired file, or fill/type the file name into a cell (which ever is easier), and the macro will auto populate that files sheets into the appropriate overview.xlsm scenario sheets. The copy/paste range will always be the same based on the sheet number.

Hopefully this wasn't too confusing. Any advice?

THANK YOU!!!!