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