Gather data from different excel tables to create charts and graphs

[trochovsky]

Hello everyone,

At the moment I find myself working with data from questionnaires carried out in five different countries and thus I have different tables, one for each of them, in different excel files.

For example:

Regarding a certain question, I have this table for France:

And this other, in another Excel file, for England:

Knowing that I have five countries, what I would like to know if is there a way to group the data of different excel files into one, and draw the respective table and graph, something like:

As I have alot of questions I would like to automatize the process instead of doing it manually,

Thanks in advance!