Copy Data from one sheet to another if column data matches

Hello,
I have two sheets of data Sheet1 is the master with Columns A to O populated. Sheet2 has 5 Columns of data A to E, Column A of this sheet holds the same data as Column E in Sheet1.

I would like to add Columns B,C,D & E of sheet2 to columns P,Q,R & S of Sheet1 only if the Column A of sheet2 and column E of sheet1 match.

Could someone help? I've spent all evening trying different methods from Google searches.

Maybe:

Please Login or Register  to view this content.

Sorry Stnkynts, I dropped the code into a Macro, checked the sheets, they are named fine. nothing happened. I am a newb and am probably doing something wrong with your code.

Can anyone point me in the right direction, the code could be fine. I'm sure it just drops into a macro.