Separate Categories into Tabs

Hi Expert,

I would like to seek your expertise in solving my problem.

I have a set of data that comes in every month, which I need to sort them to individual tabs based on the 'Auditor' column. As more data comes in each month, it's really tedious to do it one at a time. Hope for a button, which I could click on so that the data could separate itself to different tabs.

Understand that macros can achieve this and I have done a search in this forum but its quite confusing.

Hope you can help me in this.

Thanks in advance!

Look here:
http://www.contextures.com/AdvFilterRepFiltered.zip

Thank you very much for your kind assistance.

May I check if I could increase the number of columns to be copied over? Tried going through the codes but couldn't find the keys.

Thanks once again.