Excel template for Invoice, Credit Note and Receipt based on Word file supplied

I have three word files. One for invoice, one for Credit Note and One for Receipt. I want these three words files to be in one excel file as separate tabs. Attached the word and excel file. The excel file needs few input data based on which these three files should work. Wherever the same information is required, a simple link up is required. The stage in Cell B7 is a drop down Menu using options from H9 to h14. Based on the chosen stage, the Reference, amount etc should work. Other instructions are in the Input tab file. Eventually all that I will do is key in the Yellow cells in the Input Tab and the three other tabs i.e Invoice, Credit Note and Receipt should work out. Don't worry why the Credit Note (amount and date) is same as the invoice (amount & date). The information from the input tabs should populate the information in the Invoice, Credit note and Receipt tabs. The rest of the information is static.