VBA to make alot of copies of excel file

[Thriftlife]

Need help with a vba to make a lot of copies of a excel file i have. I have looked around and couldn't find anything really.
Any help would be greatly appreciated

 

[Joe4]

I think we need more information, such as:
- what is the file located that you want to copy?
- where do you want to copy it to?
- what is the logic for all the different file names you want/need? is there a listing somwhere?

 

[Thriftlife]

- "MasterFile" is the file i want to copy
- i want it to copy to a folder called "2021"
- I have a file called "Invoice Numbers" with a list from row A2 and down of the names i want the files to be named after.

 

[Joe4]

This just looks like another variation of your original post here: Need a way to create invoice numbers automatically
As we mentioned in your other duplicate post, please keep this to one thread.