I have multiple spreadsheet files, all with the same information, all
formatted the same, etc. from a template I set up.

I want to have another "new" spreadsheet that I can use to total up some key
fields from each spreadsheet. But I don't want to manually enter the file
name/path each time as each year progresses or something changes in the file
name/location.

Can it be programmed to query all files in the folder of this "new"
spreadsheet is located in, with the exception of the total "new" spreadsheet
file, to capture the file names, then I can simply add the sheet/cell
reference I need to capture to sum the data?

This will hopefully save me from having to open each file up and manually
summing up fields or maintaining a bunch of file names.

Any help is appreciated.