Do you have a list of those account numbers anywhere other than on those
tabs. If so and you can dump a list of them onto your new sheet, then take
a look at the INDIRECT function, eg

Assuming you the account number
5458467

and you had a tab named like that, then you could reference A5 like
='5458467'!A5

or assuming you had your list of account numbers in Col B starting B1, then
in A1 you had

=INDIRECT("'"&B1&"'!A5") and copied down

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Kel" wrote in message
oups.com...
The sheets are named with unique loan numbers, ie 0157654 and 5458467.
The cells are text, in cell A5. I want to create a new worksheet/book
called All. The A1 value in All would be equal to A5 in 0157654, the
A2 value in All would be equal to A5 in 5458467, etc.

Ken Wright wrote:
Examples of sheet names and what cell you want?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission
:-)

--------------------------------------------------------------------------
--

"Kel" wrote in message
oups.com...
I have a spreadsheet with over 200 tabs/worksheets. I want to copy
the
same cell from every worksheet into one sheet into a single column.
The worksheets have unique names. Is a macro the easiest way to
move
the data? If so, how can I set the macro up to go through each tab,
so
I don't have to go to each tab and run the macro separately?

Thanks,
Kel