Copy data rows from multiple worksheets, paste into one worksheet

I have multiple worksheets with different amounts of rows. The columns are the same though. No headers.

Would like to, for each worksheet, select all rows with data and put them into a Master worksheet placed before all worksheets. Beginning with the first worksheet, then add rows from the second worksheet, then from the third and so on.

When the code is run twice, it should delete all data in the Master worksheet before copying pasting again.

Maybe:

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

I get an outside interval error at
Sheets("Master").UsedRange.Offset(1).ClearContents

Is it possible to let the code create a worksheet first named "Master" and place it at the beginning?

If afraid I don't know what an outside interval error is? Try.

Please Login or Register  to view this content.

Hello John

Thank you for helping me out with this, it's been greatly appreciated!

You're welcome. Glad to help out and thanks for the feedback and the reps.