You have 2 options as far as i know, but both will require some setup work.
1) VBA.
A macro could easily open an extract and combine data into 1 report with index and match, but you would need to know the file path and name and then be able to code it. not particularly hard but if you have never used VBA you would have a fairly steep learning curve
2) Power Query
As I said before I don’t know a lot about power query but from what i have read you can import extracts from a folder and hit refresh and the combining will be done - you would obviously need to do it once and set it up but then I should be a fairly quick refresh.
|