How much date you enter in each sheet ?
You can create links to each worksheet cell if you know that.

I like to use a macro that with one click create a new sheet with all the data I want.



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"HERZHIS" wrote in message ...
I wish I had stayed on top of my VBA, Do you have a Excel function that I
could do
--
Thanks again, Herz and His


"Ron de Bruin" wrote:

Hi HERZHIS

You can find a lot of merge examples on my site

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"HERZHIS" wrote in message ...
My boss is afraid of Access, so I have to do my entire database in Excel, I
have 2 sheets that 2 different people will be entering data into, I need
these 2 sheets to become one for my boss to review but still have them
entering in their indivdual sheets and the data automatically update into the
Summary sheet for my boss


--
Thanks again, Herz and His