Automate Workorder creation using excel data (Workorder is in Excel too)

We have 1000 site locations that are in a list in Excel, each row is a different site location. We have an excel form that needs to be filled out, 1 form per site. The form needs to be populated with 10 different fields that each row has. We are open to how you could make this output work. It could create a new worksheet with each filled out form, you guide us on what is possible.