I am trying to explore possibily of printing customer customer invoices for a
sales register that I can import into Exel.

Right now all of my custom forms (every customer requires its own progress
billing form) are in PDF with fill-out boxes which are manually filled out by
a biller.

Is there a possibility of a macro that will for each record (one row on
Exel) will open a template (PDF with data fields), populate it, an upon user
confirmation go to the next record (next row in Excel) and repeat the process?

If PDF files (which I already have) are not compatible for the above
process, then I assume I need to redevelop the form library in Excel before
working on a macro?
What is be best option for redesigning forms, if I need to redo them, so
that I can later get the most from macros?

Thank you for any guidance in this matter,

Floss