Copy entire row FROM ONE worksheet TO MULTIPLE worksheets IF criteria met

Hi everyone,
This forum has been great in helping me with VBA's, but I'm now looking for a complicated macro which I have not seen here yet..

I have a master sheet with many rows and columns, relating to jobs. Column H lists date and time in this format: DD/MM TTTTz (e.i 31/01 0800z) I would very much appreciate a macro which would copy entire rows from this master sheet to sheets called "january", "february", "march" etc. according to cell H in my master sheet. The problem is that column H needs to stay in the same format (DD/MM TTTTz).

Since I want to avoid having duplicated rows in january, feruary, march, etc. I would also like the macro to delete duplicate rows but not only according to row H (more than one job can be posted at the same time) but also according to row D and F.

Any ideas would be greatly appreciated!
Many thanks!
Luke

hi arlu1201 - here's the file, thanks for your help (and the upload instructions)

hi arlu1201, the "z" in time stands for ZULU- universal time, due to the nature of our business we cannot work in local times and company guidelines make us add the "z". Unfortunately, I can't get rid of it...I was thinking of a macro which would look into cells in row H and identify the 4th and 5th character, if the 4th character = 1 and the 5th character = 2 then 12 = december, if the 4th character = 0 and the 5th character=3 then 03=March...but I had no idea how to put that into a code...Do you think it's possible?

Hi Mike,
Thanks for the code, but I'm getting an error on this line:
sMonth = Split(Left$(aArr(i, 8), 5), "/")(1) & "/" & Format(Date, "yyyy")

Any ides?
Thanks,
Luke

Hi Mike, I'm using a PC and Microsoft excel 2010..
I put all the data in a test workbook and moved rows by mistake so apologies for my previous post... Your macro is working, but it somehow stops copying from my "master" sheet on row 41.. I will keep adding entries to my "master" sheet so is there a way to extend it beyond row 41?

I can't thank you enough Mike!!
Luke

Mike this is brilliant!!

I honestly can't thank you enough!

Luke