VBA to copy a template from one sheet to another based on dropdown

[altizerc2196]

Hello! New to VBA and I've looked through every post I can find that would fit my use with no success.. I am trying to copy a schedule "template" from one sheet to another based on if a data validation dropdown matches the value in row 1 of the second sheet.

Dropdown is in Sheet "Add A Project" Cell B3 (Cells B3:D3 are merged if that matters). Validation options are currently "Sell Sheet", "Website", "Media Execution", and "Media Reporting". Validations are pulled from Sheet "Schedule Templates" Range A:AA

"Add A Project" Sheet:

Ideally, if I selected "Sell Sheet" from the data validation dropdown, it would search Sheet "Schedule Templates" Range A:AA for "Sell Sheet", Copy the schedule template from below "Sell Sheet" (In this case, Schedule Templates!A2:A16) and paste back into "Add A Project" starting at B8. If I selected "Website" It would do the same thing, but resulting in copying Schedule Templates!B2:B24 to Add A Project!B8.

"Schedule Templates" Sheet:

Desired Outcome:

I am unable to use formulas like xlookup or vlookup in column B because it interferes with other macros I have in the workbook.

I'm at the end of my wits, so many thanks in advance and please let me know if there's any other info I can provide.

 

[altizerc2196]

Many thanks John, I'm up and running! Appreciate your help