the sheet names are account numbers and I am trying to extract the account
name, the account number and the account total (eg. cells A1, A2, A3) into a
list on a new worksheet. Do you you know how to do this?
moushami

"Ken Wright" wrote:

Various ways - what are the sheet names like?

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

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

"mnirula" wrote in message
...
This is a very simple task. I simply want to create a summary list in a
column of the exact same cell in multiple worksheets. I know how to
compute
a formula using the same cell across multiple worksheets but can't figure
out
how to do this. I have tried several queries using the search function
using
key words but haven't been able to find the answer. Any help will be much
appreciated.