Everyday I need to make a copy of a worksheet and add it as a new worksheet
and then update the new worksheet to reflect today's changes. I need the
summary worksheet to be able to recognize the new data in the new worksheet,
as well as the existing data in the previous worksheets..

Summary = Worksheet A + Worksheet B + NEW WORKSHEET(Worksheet C)

The desire is to pull certain cell's info (same cells each worksheet) and
capture their data on the Summary.

Is there a way to do all of this with a macro?

Any info would be greatly appreciated!
Thanks