Cannot get VBA to work correctly to just pull one sheet

[Topdrop18]

Hello,

I am trying to get the following code to pull from one sheet in a workbook, not just whatever sheet is active. I know that I need to put something like

Please Login or Register  to view this content.

in here, but I cannot get it to work. The rest of the code works perfectly because I am trying to pull in a bunch of data from different workbooks into one sheet. The problem is that it will only pull the data from the active sheet in each workbook. The data needs to be pulled from "sheet1". I believe the line of code that I need to change is

Please Login or Register  to view this content.

but I could be wrong. Thanks for your help.

[shg]

Try this, completely untested:

Please Login or Register  to view this content.

[Topdrop18]

That works, but I still need it to just pull from "sheet1" in each workbook. Can I add anything in there to make it do that? Thank you.

[shg]

Please Login or Register  to view this content.