1. All the data files are emailed to me. Currently I save them in different places.
                                       C:\FlexibakeConversions\Data
                                       C:\Albany\data
                                       C:\midstate\data                     
                                       C:\ahold\Data
                                       C:\kkb\data
2.    C:\midstate\data\08.15.20_Recap.xlsx
       C:\ahold\Data\0056919000647_0004353672.csv
       C:\FlexibakeConversions\Data\HEIDELBERG-INVCR092220.csv
3.    .xlsx
       .csv
Not a bad file system, but I strongly recommend that you reverse the Folder names and place all inputs in subfolders of "Data". That would make it much easier to code and easier to backup and easier to move when the time comes. You can also think about adding a SubSubFolder "Archive" to each SubFolder

Other than the editorializing in re Locations, note the details below

Client
 Data Store Location File Name Patteren File Type
Flexibake C:\Data\Flexibake HEIDELBERG-INVCR & 5 digit number csv
Albany C:\Data\Albany ? ?
midstate C:\Data\midstate DateFormat("mm.dd.yy") & _Recap xlsx
ahold C:\Data\ahold 13 digit numer & _ & 11 digits number csv
kkb C:\Data\kkb ? ?
? C:\Data\? ? ?
? C:\Data\? ? ?


Can you fill in the blanks above So I can start a Workbook for this Project? Also tell me what you intend to do with the Location directory tree.