Returning values from another sheet which works when dragged horizontally and vertically

Hi,

I want to know what formula or collection of formulas i should use to pull information from several worksheets onto a single one.

I have a workbook and each worksheet is a separate country, all the data in each worksheet is in a standardised format. So for example the population of Canada in 2000 sits in B24 on the Canada worksheet and the population in 2001 sits at C24, the population for the USA in 2000 sits at B24 in the USA worksheet, ect.

I want to be able to use a formula which will be able to self populate vertically and horizontally.

I have used the formula Indirect(concatenate(A$2,"!B24") where A2 = country but this doesn't allow me to drag horizontally to populate subsequent years.

Can't post a sample im afraid, its sensitive data.

Perfect, i knew it was possible, thanks Siva