Is there anyway of automatically picking up a figure from a specific
cell on various worksheets buy using the worksheet name?

I have a spreadsheet that has worksheets with the clients contract
numbers, e:g each worksheet would be named something like this:
000/12345678/123

I also have a spreadsheet with all the above contract numbers listed
which looks up the clients names and addresses etc. The data on each
sheet is always in a specific cell on each worksheet for the sake of
argument cell A1.

I would like to use the spreadsheet with the contract numbers listed to
look up cell A1 on each spreadsheet by using the worksheet name (i.e.
contract number)

Any thoughts?

Thanks