Copying rows to a new sheet based on value in row G

[victoriabrown]

I am very new to VBA and am desperately trying to do something. I have a spreadsheet with several sheets. The first sheet is called Support Log and contains rows of data the other sheets are called "HART", "Athena", "Hotel" and "Internal". In column G there is a label of either "HART", "Athena", "Hotel" or "Internal"

I would like to copy the entire row to a new sheet of the same name for each of the labels. i.e. in the HART sheet I would like to be able to view all the rows from the Support Log sheet that have been labelled HART and then the same for Athena, Hotel and Internal.

It seems like it should be such a simple thing to do but I have read pages and pages of threads of other people trying to do similar things and have tried to modify the code but I just can't get it right! Can anyone please help me?

I thank you in advance for any help you can give!