compile data from multiple worksheets into one worksheet

[wtuttle]

Will someone please help with a macro that performs the following:

1) I have multiple workbooks each with various worksheets. Each workbook has a specific "Invoices" worksheet. I would like to extract all the information from each "Invoices" worksheet and compile all the information in one "Total Invoices" worksheet in a stand alone workbook.

2) As information is added and/or changed on "Invoices" worksheet the compiled "Total Invoices" worksheet is updated

3) Also, the individual rows (each invoice entry) compiled should automatically be sorted based on entries of:
paid
due
overdue

Thanks in advance

[davesexcel]

Sure we can help, what do you have so far?

[wtuttle]

To be honest I am a VBA novice and do not know where to begin.

[wtuttle]

I have attached one of the "Invoices" spreadsheets.

If only the first question can be answered then it would be a great help.
Please disregard questions 2 and 3.