Extract info from Excel spreedsheet into Word document template

[MD2015]

Hi,

I would like to extract all info from excel tables into a word document verbiage by creating a macro/vba but my data is not set up consistently. There is not a consistent range as it varies daily and there are three different entity category(ABC, DEF, etc)

I then copy each of the information from the cells one by one and place the info in the word template. Can someone help me simplify this process and how i could automate this by copying the info into the appropriate template (depending what the account number starts with). below is an example of the excel spreadsheet set up.

Much appreciated!!

ABC <tbody> </tbody>	<tbody> </tbody>	<tbody> </tbody>	<tbody> </tbody>
Account Number <tbody> </tbody>	ML	Symbol	Company Name
5XXXXXXX <tbody> </tbody>	1	2	3
DEF
Account Number	ML	Symbol	Company Name
2XXXXXX	1	2	3

<tbody>
</tbody>