I have a file that has many multiple tabs with data in in each tab. Is there
a way to combine all the Tabs into 1 sheet? Without using the Cut & Paste
You can using macros..Check out the article by Ron de bruin on "Copy from row
2 till the last row with data"
If this post helps click Yes
You may get some hint from this link -
Microsoft Excel MVP