Macro

Hi,

Im trying to do a macro that will move data from a number of sheets based on a flag in column W on each sheet.

Basically if the flag in column W is "YES" then i want it to copy the whole row and append it (if thats possible?) into the sheet 'Journal'

I have attached a cut down version with only 3 sheets (one of which is the 'Journal' sheet) and only a few rows on each sheet.

Firstly is this even possible and if so how would i go about it? i know very little about VBA so any help whatsoever would be very much appreciated.

Thankyou
Marc