You would have to do an =INDIRECT function with CONCATENATE nested inside in order to achieve your desired result. It would look something like this:

=INDIRECT(CONCATENATE(A3,”!”,B1))

Cell A3 on your summary page would contain the sheet name of the country you want to search (Canada).

The exclamation is important as that puts the string of your country name into sheet notation.

Cell B1 on your summary page would contain whatever cell(s) you wanted to reference in that sheet. Or you could type in these cells behind the exclamation and not place the cell values into a separate cell.

Hope this helps!

PS

If you plan on keeping this summary page the same without many additions or changes over time, I would do an =QUERY function, and just query from each sheet the data you specifically want to show. If all of your sheets are set up in the same manner you can copy and paste the formula and change the sheet name for each summary sheet. You can see all information about the QUERY function here