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!