Simple version: Each day a worksheet is created with revenue data. This data is then used to update 22 other standing worksheets. Can Excel be configured to automate this process? Perhaps with macros?

Details: Data is collected daily from a series of ATMs. This data is then used to update individual spreadsheets for each machine location. Looking to update the entire spreadsheet set up and wondering if there is a way to automate some of it. I know I can link from many worksheets (files) to one, but can it be done from one to many when the one is newly created (named) each day?