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.

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.

Hi GMP

Try this
http://www.rondebruin.nl/summary.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"GMP" wrote in message ...
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.

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.

Assuming 12 sheets named as per your example 'mmm 2004' with data in say
cells A1:A4 on each sheet to be returned to the summary sheet

Summary sheet:-
B1:M1 = Jan, Feb, Mar, Apr..........
A2:A5 = 1,2,3,4 (represent row numbers of data to be returned from each
sheet)

Cell B2 = =INDIRECT("'"&B$1&" 2004'!A"&$A2)
Copy across B2:M5 and all data will be returned. Dollar signs on the 1 and
the A simply lock those row and column references for when you copy the
formula across the other cells.

use same principle but adjust for your ranges

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

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

"GMP" wrote in message
...
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.