Hi Jimenda

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

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


"Jimenda" <Jimenda@discussions.microsoft.com> wrote in message news:49CADE31-92C4-4C6C-9C5A-760571C9152B@microsoft.com...
>I have 55 sheets in my file. I have one page that I am collecting data from
> other sheets. So on the individual sheets I will have the same data for
> different dates in cells C7 C14,C21,C28,C35,C42 and so on. On the sheet I am
> collecting data I will have a list of the indidvidual sheets and columns
> labeled with the individual data to be collected there. What I need
> assistance with is this:
> If on first row of my collection sheet I pull info from sheet #1
> C7,D7,E7,F7, AND G7 and I would like on the same row to then pull from the
> same sheet C14,D14,E14,F14 and G14, and then C21,D21,E21,F21, and G14 and so
> on and so on. How do I copy and paste my formulas? Can I increment a formula
> so when I copy it to a different rows it will automatically increment the
> formula to pull data from the next sheet? Don't know if it possible, but it
> woul sure save me time.
>
> --
> Thank You & God Bless,
>
> Jimenda