Merging Worksheets with Different Number of Entries

[chisholm.alexander]

Hi Everyone-

I've got a workbook with some 40 worksheets containing macroeconomic
data for a number of countries. The problem is that some worksheets
have data on a certain number of countries, while others have more or
less.

What is the easist way to populate one worksheet with all of the data
(where missing info for certain fields would be left blank)?

Let me know your thoughts, thanks!

Alex

 

[chisholm.alexander]

Clarification Example

Worksheet 1:
Italy 30,000
Germany 25,000
France 28,093

Worksheet 2:
Italy 4.5
Germany 6.8

Worksheet 3:
Italy 344
France 223
Spain 112

I want to simply create Worksheet 4:
Italy 30,000 4.5 344
Germany 25,000 6.8 -
France 28,093 - 223
Spain - - 112

This is obviously a simplification. The workbook contains a couple
hundred countries..

Thanks again

Alex