See:

• Automated Boilerplate Using Microsoft Word as a start, especially AutoText.
• Create a Simple Userform - a vba method of utilizing AutoText, choosing templates, etc.
• Global Template - a holder for AutoText and Userforms

Bringing in Excel data will require some standardization of where that data is stored.