I see no advantage in doing this. I can't tell what you have to do, but if you divided the data on the several sheets, you must have a reason to do that. If you have a reason, why join then together ? It makes no sense to me. All right, what I would do is, why do I need to see then in the first place, all together ? It just makes it difficult to find anything, Wait, yes, only if you want to use the edit function to locate specific data on it. But, do you have to do it many times ?
I would, if there are anything related, make, for ex, a SUM or other resume in each sheet, and in the new sheet make a cross reference for that field on each separated spreadsheet.to consolidate the data, without copying the whole data to just one sheet. If you are a good programmer the first solution for copying it may help, but it is not that simple, you'll see.
And last, but not least, if each sheet grows in row numbers, make sure, the SUM or whatever else be on the topmost and rightmost, so the sheet grows but the consolidate data don't get affected.
Have you tried using the consolidate feature?
– CharlieRB – 2015-09-25T12:55:43.007