Macro to copy rows from multiple sheeets with a criteria to another sheet

[Mali]

Hi all
Can I request your expertise to solve a macro problem.

The attached workbook has got 6 sheets.
Sheet 1 is 'Home'
Sheet 2 is 'A'
Sheet 3 is 'B'
Sheet 4 is 'C'
Sheet 5 is 'D';and
Sheet 6 is 'Consolidated Action Sheet'

Some of the rows in Column F in each sheet has got a text 'Action Item'

I would like to have a macro which helps me to collate all the rows from each sheet with the text 'Action Item' in to the 'Consolidated Action Sheet'

Would be delighted if you can incorporate a step that auto update the Consolidated Action Sheet' when ever data are changed in the relevant sheets

I have tried different options to do this job and you can see my different macros in each sheet.

I am using 2010 excel.

Looking forward for your replies

Thanks guys