They should be in the same folder as the 'Master' or the all date WB with a name like

C:\Users\Ray\My Documents\Sales\Sales2020-2021-04-07-East

so if the 'All Data' WB is "C:\Users\Ray\My Documents\Sales\Sales2020.xlsm"

the WB for the East department generated on April 7, 2021 would be


"C:\Users\Ray\My Documents\Sales\Sales2020-2021-04-07-East"

where

wb.Path = "C:\Users\Ray\My Documents\Sales"

Application.PathSeparator =""

Left(wb.Name, InStr(wb.Name, ".") - 1) = "Sales2020"

"-" & Format(Now, "yyyy-mm-dd") = -2021-04-07

"-" & pi.Value = -East

        'make file name
        sFilename = wb.Path & Application.PathSeparator & Left(wb.Name, InStr(wb.Name, ".") - 1) & "-" & Format(Now, "yyyy-mm-dd") & "-" & pi.Value
I prefer to keep generated WBs in the same folder as the source, but you don't have to

I prefer to tag generated WBs with a timestamp and maybe a identifying tag