How to link data from multiple worksheets which uses the same cells values

[Corried]

Hello Excel World:

I have a problem.

I want to extract data to create a list from workbook (B) into another workbook (A).

NB: Using the "=" sign is hard and long to extract data.

So my point is:
On workbook (A), I have a list of countries names from row A2 to row A51
Next. On workbook (B). Each country has it own "worksheet". From worksheet #1 to Worksheet #50 and all the values are in cells "F2 & G2" respectively.
I want excel to grab each worksheet values in "F2 & G2" in workbook (B) and paste it as a list in workbook (A) in worksheet (1).

How can I do that?

 

[offthelip]

Put this code into workbook A and then change the line:
Workbooks("Book2").Activate to what ever the name of workbook B is.

Sub test()
wbname = ActiveWorkbook.Name
countries = Range("A2:A51")
outarr = Range(("B2:C51"))

Workbooks("Book2").Activate
For i = 1 To 50
If countries(i, 1) <> "" Then
Worksheets(countries(i, 1)).Select
  temp = Range("F2:G2")
  outarr(i, 1) = temp(1, 1)
  outarr(i, 2) = temp(1, 2)
End If
Next i
Workbooks(wbname).Activate
Worksheets(1).Select
Range(("B2:C51")) = outarr

End Sub