I've looked at the code in the post you referenced, but I have not been able to figure out how to make it work in my situation.

I've done some reading and have figured out that I should be able to retrieve the data from the source workbook without actually opening it if I use the entire file path. I'm hoping that would solve the problem of having to reactivate the "Test" file. However, I'm too inexperience with VBA to know the syntax necessary to accomplish this. I need to include the name of the worksheet in the source workbook as well as the file path.

I would greatly appreciate any help.

Thank you.
Mikki