Extracting Worksheet from multiple files + consolidated them...

Hello,

What is the best way to accomplish the following?

1. Extract Sheet7 from multiple excel files (the files are budget templates, so they are exactly the same). The sheet 7 has formulas, so I would need to extract the values.

2. Load Sheet 7 into one excel sheet (Sheet 7 tab name is different in each excel file, but it is Sheet7).

3. Using the same template format, I would like to combine all the values across all the sheets into 1 worksheet. I.e. Take the value in "A7" from all the worksheets and sum it together into A7 on Sheet1.

I hope this makes sense.

Thanks!

Wow thanks! Let me play with this and see if I can get it to work. I'll report back. :D

Quick question: It states that 'Sheet7' in your map: "Variable Not Defined"

\1

Hi,

can you try once with

Please Login or Register  to view this content.

instead of sheet7