HELP needed! Form creation with help of Macro

Hi All (Genius)

I would be greatly thankful if anyone can help me to create form (example attached in file) for payment order with the help of macros or anyother useful method. The data is in input tab in file with 3diff currencies and on the basis of this I need three different form, input data highlighted in green. Also this data is variable on the basis of input tab rest of data is fixed in form (attached as example 3 required tabs PO USD, PO SEK & PO EUR)


requirement is to create same kind of form in 3 separate file or sheets (1st three tabs purchase order) from the variable data (highlighted green) from input tab, Po form layout example is *P Order - EUR*

Please let me know if you have question regarding my request, data is just a example.

Thanks in advance for help & support

Best Regards
Cameron