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