I have a excel workbook that I get on a monthly basis that has 30 tabs (worksheets) each containing different sets of data. Is there a way to consolidate all the information into one tab without cut & pasting all the information from one tab to the other to get a so called "consolidated worksheet"? The column headers are always the same, just different numbers of rows each day due to different activity.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multiple Excel Worksheets into one consolidated
- Thread starter Noah114
- Start date
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red][/red]![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Status
