data transfer code issue

The following code (made with the help of people on this site) allows me to transfer data from multiple sheets in the workbook to a single data sheet. I now need to add a reports page to get the most out of the data, but cant seem to figure out how to stop the "data" sheet code from pulling my pivot table on the "reports" page. Any help would be appreciated.

Please Login or Register  to view this content.

Assuming the new sheet is called "Report", this line of code:

Please Login or Register  to view this content.

...is added onto:

Please Login or Register  to view this content.

i will try that.
Can I add endless sheets the same way just by extending the string?

Certainly, but there are numerous ways to slay this dragon. If a workbook has 20 sheets and you want to import only a few of them, it might be easier to list the ones you DO want instead of an ever-growing list of ones you don't.

Another way is to put a common unusual character in the sheetname of the ones you WANT to import. Perhaps a pipe character |
This way you can write code once to only import sheets with that unique characteristic, and in the future no code edits are needed to change the included sheets, you can do it on the fly by adding/removing that unique characteristic.

The same idea could be applied to a unique characteristic found on the sheets themselves. Perhaps the sheets to import all have a common text string not found elsewhere in the document..... hehe, like a cell that says "import me".

thanks for the quick resolution