From data form, have other forms auto fill

Hello, looking for suggestions on if possible within Excel:

Step one: Fill out data in an Excel form. e.g. material codes, cost, inventory location etc.
Step two: Auto fill two different forms from this information (such as a delivery note and customs docs for supply chain).

Is this more for Access or is this easy enough in Excel?

Let me know any thoughts/suggestions.
Thank you,

Is this what you want to do - fill left form - others should fill as you type.