Consolidate Mulitiple Tabs

[Yippy_Kiyey]

Hi,

Someone sent me a spreadsheet with 35 identical tabs. (Spreadsheets).

What is the easiest way to consolidate these into one spreadsheet?

The numbers of rows are not the same but columns are the same.

Thanks ,

Rey

 

[hiker95]

Yippy_Kiyey,

Do the worksheets contain a title row? If so, what row are the titles in?

Can we see a sample of one of the worksheets?

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

Or, you can upload your workbook to www.box.net and provide us with a link to your workbook.