hi ken
maybe I'm not expressing myself clearly. Lets say I have three worksheets
named account a, account b, and account c. I insert a worksheet in the
beginning of the workbook. I want to copy cells A1, A2, and A3 from all
three worksheets into the newly inserted worksheet in a column or a row.
What is the formula that allows me to do this instead of copying and pasting
from each individual worksheet which can be quite time consuming? Any
suggestions?
Thanks
moushami

"Ken Wright" wrote:

If you'd care to give an example of a couple of sheet names, (or you perhaps
have a list of these accounts that you can use) an account number (By all
means dummy it up, but make sure it is representative) then maybe I can give
you a formula example.

One option may be to use the INDIRECT() function that allows you to build
range references from strings of data. If you already have a list of the
accounts (which I assume are the exact sheet names), then we can probably
help.

--
Regards
Ken.......................

<snip