Concatenating spreadsheets

Question

I have a number of spreadsheets, each has the same format. Each has 9 tabs. Instead of twenty separate spreadsheets, I would like one, big spreadsheet with all nine tabs. sure, I can cut and paste, but after the first spreadsheet all subsequent sheets transfer with only the first tab's data. I can accomplish this with VB6, but I was wondering if there is a way to do it with the tools of Excel.

Answer

Not sure about the reference to VB6 (though it can certainly be used) but I would suggest VBA as being the way to go - as far as I know, there isn't a direct process for combining sheets, but VBA could easily loop through all files in a folder appending data to each page as it goes - happy to help with any coding you need, though the indications are that you are OK with this already!