Haven't got a clue!!!

Here is a cut down sample of a spreadsheet i'm working on.

Sheet 1 and 2 are updated daily, and i need sheet 3 to update automatically taking the required data from the other 2 sheets, depending on whether or not the approval column is Y or N.

This should be fairly straightforward but I haven't coded in a while and have never used VBA.

Any help would be appreciated.

Thanks

- DarrenG