Macro to filter active ws in workbook and paste filtered result in "result" worksheet

I am trying without success to create a macro that will display filtered results in another worksheet. Attached is a copy of the file scenario. There are several macro attempts within the file but I cannot seem to set autofilter ranges

Basically for tyhe activesheet in workbook (except control sheet) the range a3 to last entry in column s or t needs to be filtered by column 3 with the criteria1 being "M" (for major work)
That filtered result would need to be pasted to the next available row in worksheet result, and then the autofilter to be turned off

explanation repeated in control sheet of workbook attached
Any help would be appreciated


I posted a different approach to the same problem in the Excel 2007 by mistake, and have been unable to remove, I hope the moderators will overlook this as I have tried to contact them to remove the post so I could repost here in the programming section

Many thanks Nigel