Combining information from multiple workbooks into single graphs

Hello!

I have five quarterly reports, which are different Excel workbooks. Each of them has multiple Sheets. There are hundreds of values, but between the workbooks they are always at the same location, in the same columns and lines. There will be more quarterly reports that follow these same rules.

I want to create some kind of a neat solution, where I click on a value, Excel will pull the same data from all of the quarterly reports and put it into a graph/chart for quick visualization, and also have the numbers on the chart (like you can do in a normal Excel chart). Clicking on multiple values would pull up multiple charts, so I can compare, see correlation and whatnot.

Something like that.

I found guides on how to pull data from multiple workbooks, but I don't want to go through the same setup hundreds of times, because I have hundreds of data fields. There must be a quick and possibly robust way to do that, right?? Since I am an Excel novice I don't really know what to search for (I tried).

I hope somebody can help me or guide me in the right direction