Merging two or more sheets into one sheet

I need to merge some sheets together in a spreadsheet. There are a few I need to merge so I am thinking of using a loop and variable names to merge different sheets together. My sample has random letters and numbers to save time while making the sample. For example I need to merge sheet 1 with sheet 2, also sheet 3 with sheet 4 so I end up with two sheets in total after the operation.

Why not one master sheet?

I need to keep the specific sheets separate from each other as they some will hold information related to some sheets but not others

Despite your file appears to be small, it is not. It is too big for the size limit of this forum.
I know this issue. You have copied, or downloaded the data from an application, like SAP. It is nightmare to work with data imported in to excel with out first converting these data in to values ONLY.
Your data have almost crashed my PC. It might not crash yours, but I bet you the code will take ages to run.
So, please do the following:

Convert any data imported in to excel in to VALUES ONLT FIRST before you use the data in excel.
I have two codes, the master for the first two sheets and master1 for the other 2.

Please Login or Register  to view this content.

Sorry about that AB33 didn't realise I had done that. Will fix it if I am uploading files from now on. You've been a great help for a beginner such as myself. I will give this a go and let you know how I get on.