Single Cell, Multiple Worksheets

[ms.fb]

I have a workbook that contains 19 different worksheets. They contain the same format of data, but it applies to different business units.
I want to pull a specific cell value for each store.

So for example I want to see how each store did in Gross Margin (cell J20), so I want to list the stores (workbook names OR cell A1 in each workbook) from all workbooks into one worksheet (sheet 1).

Any thoughts?

[moinsk21]

Hi,

Select All Sheets and input the detail in one sheet, so it will update to all sheets.

Thanks!
Moinuddin Shaikh

If you like my Response:
1. Show appreciation to those who have helped you by clicking below their posts.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

Appreciate someone towards their career path is better than saying Thanks!
-Moin