import data from several spreadsheets into one spreadsheet

[RELIANCE]

How do I consolidate several spreadsheets into one spreadsheet with each
spreadsheet on a different tab in the new spreadsheet? How do I do this with
the least keystrokes?

 

[Gord Dibben]

You have several Excel Workbooks that you wish to combine into one Excel
Workbook............right?

How many Worksheets does each Workbook have?

Or does each Workbook contain only one Worksheet?

You can copy a Worksheet from one Workbook to another but you cannot copy an
entire Workbook to a Worksheet in another Workbook.

Please clarify your needs.


Gord Dibben MS Excel MVP

 

[Ashish Mathur]

Hi,

You may refer to this article

http://datapigtechnologies.com/blog/index.php/using-access-to-combine-multiple-excel-files-method-2/

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com