How to make comparison chart to display two varying

[Corried]

Hello.

I am not sure if you can help me. I just don't know...

I would love to know, how to make comparison chart to display two varying sets of data.

I have two workbooks.

One of the workbook have 181 worksheets. "Each worksheet name after a country and have its own data.

Next

The other workbook have 185 worksheets."Each worksheet name after a country and have its own data.

This is the hard part:

#1 How can I link both workbook data together using macros? Country vs Country or USA vs USA as an example.

#2 How can I create a comparison chart to display two varying sets of data, both varying sets of data beginning with the zero values?

If you think I sound crazy. Please just say so lol. I am not sure if you are open in helping me. If so, I am looking for someone to point me to the right direction.

Thanks in advance

Cheers,

Unemployment_Rate.xlsm

drive.google.com

GDP_Annual_Growth_Rate_%.xlsm

drive.google.com