Auto copying from one worksheet to another in same work book

Hi Folks,

My apologies if this thread has been done already but I'm new here and need help!

I have a Workbook that records incoming documents to our office on a monthly basis. At the end of the year, all of this information is copied to a new worksheet labeled "All" and acts as a summary for quick searching (I know that sounds like a gross duplication of work but it's how my supervisor wants to do things).

Is it possible to set up a function or macro that will auto populate the "All" worksheet from new information entered into another worksheet to save having to copy twelve months worth of incoming documents manually?

I've attached a working copy of the master spreadsheet so you can see what I'm dealing with.

Thanks very much.