I nee some help and ideas on how to accomplish my goal. I daily have over 40 new spreadsheets with data, all have one worksheet and all saved with different names. All these spreadsheet are saved into a date folder (example Folder Name = Dec 18).
I need to pull data from all these files on a daily basis. So on Dec 19th I need the data from the Dec 18th Folder. ALL data falls in same cells.
So in all files I would need cells (b8-b10,d7-d10,e7,a242-d260, & a244.)
I need some ideas on how I can pull all the data from those spreadsheets into one without changing the files names and not manually having to go into each one grabbing the data. Any Ideas?