Hi all,
I've been able to put together the following code with the help of many of this forums' members.

Problem:
I need to modify the code to copy the same range of data from multiple sheets into a summary sheet which is located in a different workbook. I cannot get the following code to run through all the sheets in the target workbook. I only get the first sheet. I've been pulling my hair out and searching the forum but I cannot find a problem like this....

Anticipated corrections needed?:
1. Does not cycle through all sheets in the wbTargetBook. Currently only the sheet called out by (Filepath4) gets copied and pasted. I imagine I will need to get rid of this line in order to cycle through the other sheets in the workbook.

2. I always want wbThisBook to be the book I am pasting the data to. How can I code that?

3. Currently, if the code was working it would paste data on top of earlier pasted data. That is fine as I'm just trying to get the code to copy and paste from each sheet. Ideally, the for statement would include a line to skip 30 columns when pasting the next sheets data. I don't want to get too greedy with the requests so the top 1 is most important.

Thank you all and PLEASE HELP!

Please Login or Register  to view this content.