How do I make a sheet that combines all tabbed sheets & update as.

In a spreadsheet there are 4 tabs. Each tab covers a year (2000-2004). Each
tab also is identical in column names.

How do I make a page that combines the contents of all tabs and will update
as I update the related tabbed page?

Tx!

--
ahmebah

Check out HELP: on DATA / CONSOLIDATE
HTH
Gary Brown

"ahmebah" <ahmebah@discussions.microsoft.com> wrote in message
news:14347CA4-6338-4388-ABC6-1422ED5EE406@microsoft.com...
> In a spreadsheet there are 4 tabs. Each tab covers a year (2000-2004).
> Each
> tab also is identical in column names.
>
> How do I make a page that combines the contents of all tabs and will
> update
> as I update the related tabbed page?
>
> Tx!
>
> --
> ahmebah

Hi ahmebah

I have a few code examples on my site to do this
See http://www.rondebruin.nl/tips.htm



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



"ahmebah" <ahmebah@discussions.microsoft.com> wrote in message news:14347CA4-6338-4388-ABC6-1422ED5EE406@microsoft.com...
> In a spreadsheet there are 4 tabs. Each tab covers a year (2000-2004). Each
> tab also is identical in column names.
>
> How do I make a page that combines the contents of all tabs and will update
> as I update the related tabbed page?
>
> Tx!
>
> --
> ahmebah