Compiling data from multiple worksheets into one worksheet

[thelonious419]

I am trying to create a summary worksheet that will grab data from the same
two cells in everyone of my worksheets. I don't want it to add all the
values together, but I want each value to be returned to a separate cell
within the summary workseet. Is there any way to do this?

[Ron de Bruin]

Hi thelonious419

Maybe you can use this example
http://www.rondebruin.nl/summary.htm


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


"thelonious419" <thelonious419@discussions.microsoft.com> wrote in message
news:4F11D407-BD65-4946-BA93-5D58CDE6CC24@microsoft.com...
>I am trying to create a summary worksheet that will grab data from the same
> two cells in everyone of my worksheets. I don't want it to add all the
> values together, but I want each value to be returned to a separate cell
> within the summary workseet. Is there any way to do this?