Have a look in HELP index for INDIRECT

--
Don Guillett
SalesAid Software

"briank" wrote in message
...
My spreadsheet has a summary tab and 40+ supporting tabs. The summary tab
has two columns: Column A which houses 40 rows of country names and Column
B
which will have a link to each of the 40+ supporting tabs also possessing
country names. Is it possible to use a cell reference in Column B in lui
manually linking each tab? With several dozen of these spreadsheets to
create I'm looking at automating the links.
A B
1 Austria =T(A1)&!$E$10

It is my attempt for Col B to mimic "=Austria!$E$10" and return the
numerical amount in E10. Any thoughts?