The sheet names are Jan 2004, Feb 2004, etc. These are monthly financial
statements that I want to summarize on a single sheet (meaning side by side
not summed).

"Peo Sjoblom" wrote:

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.