IF A CONDITION IS TRUE THEN SPECIFIC TEXT IS INSERTED

I'm hung up here... 

What I'm wanting to do is—

Context of the issue— Writing default subcontracts for all construction disciplines to be uploaded on the server and used by multiple users, some of which are not familiar with certain disciplines. 

Specifics— I've made a dropdown list of items that the project manager may or may not need on a specific project. If they choose, for instance, "Earthwork," I would like that word to autoload text (the specific terms and conditions common to an Earthwork subcontract), on a separate worksheet, to a specific cell. I want this worksheet to compile all the contract terms that relate to Earthwork, such as Storm Sewer work, and organize them where it can be moved into Word, and uploaded into Procore, our project management software. 

I hoping the community can help...mj