VBA to copy/rename files

[three482]

Hi everyone. I’m trying to copy a prebuilt template (“C:\Users\macros\monthly log.xlsm”) and save a copy of the workbook for team members based on a list that includes the current month (for example, “C:\Users\Accounting\Sept monthly log (John Smith).xlsm”, where cell A1 = Accounting and A2 = John Smith). Ideally, I’d like to list other teams in separate columns (like B1 = Service and B2 = Jane Smith). The team rosters are maintained in a separate workbook (rosters.xlsx). Teams are also different sizes - some could have 8, another 15, and another 12.

I hope I have adequately described what I’m looking to accomplish.

Thanks in advance!