I have multiple worksheets in one workbook with list of alpha information. I
want to be able to combine all of this information on the multiple worksheets
into one summary page. This data is in three columns on each worksheet...an
example information on each individual worksheet of what I am trying to
combine is as follows:

Sheet A AA Ambercrombie Announcement
Sheet A AC Air Conditioning

Sheet B BB Best Bargain

Sheet C CC Chocolate Cookies

Without having to cut and paste into one summary page is there a macro that
I can do to combine all of these worksheets into one and how can I tell it to
automatically update when there have been additions / deletions / changes to
the individual worksheets?

--
Paula

='Sheet A'!AA
='Sheet A'!AC
='Sheet B'!BB
....


"Paula" wrote:

I have multiple worksheets in one workbook with list of alpha information. I
want to be able to combine all of this information on the multiple worksheets
into one summary page. This data is in three columns on each worksheet...an
example information on each individual worksheet of what I am trying to
combine is as follows:

Sheet A AA Ambercrombie Announcement
Sheet A AC Air Conditioning

Sheet B BB Best Bargain

Sheet C CC Chocolate Cookies

Without having to cut and paste into one summary page is there a macro that
I can do to combine all of these worksheets into one and how can I tell it to
automatically update when there have been additions / deletions / changes to
the individual worksheets?

--
Paula

Thank you so much for your immediate response. This is exactly what I was
needing. Have a great day.
--
Paula


"Paula" wrote:

I have multiple worksheets in one workbook with list of alpha information. I
want to be able to combine all of this information on the multiple worksheets
into one summary page. This data is in three columns on each worksheet...an
example information on each individual worksheet of what I am trying to
combine is as follows:

Sheet A AA Ambercrombie Announcement
Sheet A AC Air Conditioning

Sheet B BB Best Bargain

Sheet C CC Chocolate Cookies

Without having to cut and paste into one summary page is there a macro that
I can do to combine all of these worksheets into one and how can I tell it to
automatically update when there have been additions / deletions / changes to
the individual worksheets?

--
Paula