I have a workbook that has sheets upon sheets that are named with dates
(mostly two per month) Each sheet is the exact same columns. LastName,
FirstName, Date, Hired (and others)

the person that was keeping the report would copy and past at the end of
each day what she entered on the sheet to the "Consolidated" sheet.
I was wondering is there a way that I can have the consolidated sheet update
every time I enter info on different sheets in the same workbook.

I have no clue how the last person kept up with what she did each day and
kept track of it all. I am an Access user and eventually would like to take
this report there but the boss isn't willing to change yet, so I would love
some info on how I can get Excel to do this if possible.