extracting data

[ftahbaz]

Is there anyway to easily extract data from different Excel Files
(that are formatted similarly and have the same sheet names)???

For ex...I have 3 excel documents.
Workbook 1, 2, and 3.
Each has 3 sheets named: A, B, and C.

How can I extract data from all 3 workbooks into one spreadsheet
without any complex programming (if possible)?

 

[Guest]

Using in the edit menu Replace sometimes helps. If you are using links
between workbooks and have the data from the 1st work in the main
spreadsheet. the copy these cells to another location on the main worksheet.
then highlight the copied cells and use replace to change the workbook name.

The Linked names should include the $ format ($A$1) becaue if you don't, the
cell locations will change.