macro to fill a form and save one file per row in document

[Magicismagic]

Hi and thanks for quick response...
to answer your questionin red)

In what file format are you:
• receiving the reports? .xlsx
• sending the form? . xlsb
Actually, beyond knowing the file formats, before anyone could help we'd need to know how the data in both are structured. Can you attach bot a report and a form to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

and a trimmed sample..
of what it looks like... (original report and template have many more fields)
the new file should only save filled template with info tabs without "report" tab (if possible)