if you have some system in the naming of the sheets with numbers like in the
default names (Sheet1, Sheet2 etc) it might be possible. Maybe you can post
back with more info about the sheet names, otherwise a macro would be the
only way


Regards,

Peo Sjoblom

"GMP" wrote:

I want to copy a cell (say A1) from multiple worsheets to a single sheet in
different cells (say A2 thru A15) using a formula.