@BYahr
how do you currently do this ?

Currently, I manually open each of the 22 spreadsheets and enter the data from the day's file "Worksheet mm.dd.yyyy" where the data has been gathered. I've been working on this for quite a while in the spare time between other projects. I have learned a lot. What I have will work between the worksheet and one spreadsheet that I am using as a sample. I think I'll need to store a unique macro in each of the individual spreadsheets which will require the macro to identify the correct worksheet file.