Yes the code sees 3 spreadsheets in the folder VCollinsville. It opens the first one but when it tries to copy cell B2

.Cells(2, 2).Copy (Workbooks("Monthly PF Compiler").Worksheets(center(i)).Cells(MCStartRow, 1))
I get the subscript out of range error. It pulled the spreadsheet from Bothell and executed perfectly which is why I'm confused. All the spreadsheet layouts are the same.