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