i have atleast 90-100 files monthly in one folder that i would like to automatically total the amount of certain cells. all the files have the same structure and info is located in the same area. For example on the file i have attached i would like to have a worksheet that is exactly that but totals all the numbers from each of the files in a specific folder. I hope i have made sense in what I'm asking, I've searched and tried a couple of things but cannot seem to get it to work.
Bookmarks