OK, I was also not a programmer (not in VBA anyway) about 3 months back, but I was able to write a fairly complex macro, running into thousands of lines of code, by breaking down my project into tasks.

I started by googling "writing my first excel macro", and kept modifying that first macro per my requirements.

If you are willing to learn and write your own macro, folks in this forum can help you.

Here are the steps for you to start researching and get started:-
1. How to write a macro to open a file
a) given its name and directory location, or
b) by calling "Open File" method

2. How to write a macro to copy sheets from one file to another

You can start searching solution (code) for these steps - one at a time - and writing your own code. We are always here to help if you get stuck.

hth
All the best
Ajay