Seeking advice from advance excel gurus on this forum

[Matrix2021]

Hello excel world.


I am seeking advice from advance excel gurus on this forum.


Here's the concern.


I found this code with its photo below searching online:


string strCountry = US; // Set country ( sheet name )
plotxy iy:=[Book1]strCountry$!(1,2) plot:=200 ogl:=[<new template:=LINE12>]; // Plot into graph template LINE12 that is pre-created.
plotxy iy:=[Book2]strCountry$!(1,2) plot:=200 ogl:=1;
layer -g; //Group plots





My problem here is this:


#1 How can I modify this code to automatically detect, the same worksheet names on each workbook. Example: Workbook (A) worksheet (United States) and workbook (B) worksheet (United States)


Now
Workbook (A) have 181 worksheets. (Each worksheet represent a country) And
Workbook (B) have 185 worksheets. (Each worksheet represent a country) Next.


#2 How can I modify the code to create a line and column chart automatically? Placing dates on the X axis and values from both workbooks using their prospective worksheets on both sides of the Y axis, beginning from the zero value.


How can this be done automatically, filling each worksheet with a chart, while extracting data from each workbook?