Using VBA to search and fill data between 2 sheets

Looking for input on if I might be getting in over my head for a VBA beginner.

I have worksheets that have project numbers on my "Awards" sheet and people working on (potentially multiple) projects on my "Effort" sheet. The sheets are created from 2 different reports I can run very easily but the awards sheet has much more info I would like on each line the project appears on the effort sheet. So essentially what I am wanting is something like this: For each row on Effort column B, search Awards column AA for a matching value. Once the match is found, copy info from Awards columns R-Z (same row as matching value) to columns R-Z on search value row of Effort sheet. 

This seems very possible but I'm not sure where to start or if I should just abandon ship before I set sail. Any advice on where to start, tips to avoid issues, or sample code snips would be greatly appreciated.