I have multiple workbooks all identical but contain data for individual sites.
I have recently introduced a new worksheet which I created on one of the workbooks and I wanted to copy it and paste it in to a new blank worksheet for each sites own document but when I do this it also copies in the...