Hi, I have a collection of excel workbooks that I update weekly with raw data for my business. I want to be able to have this data automatically inputted into a 'Master Sheet' that will display this data in graphs etc. How would I set up my master sheet so that it automatically pulls the raw data from my other workbooks dependent on a new set of data according to date? I can provide screenshots if that helps, thanks in advance!
Excel is a very powerful tool and usually has many ways to do the same or nearly the same thing. As with everything there are trade offs and therefore the "best" way often depends on many things. That said, I suggest you consider Power Query. If you are not familiar with it find some basic tutorials/intros. Here is one: https://exceloffthegrid.com/power-query-introduction/