Merge 100 WPS Tables into Excel -- 2

I have one hundred WPS files that contain tables only. I need every row from those files imported and merged into a single worksheet in Excel. All the data must appear on one sheet, even though the original tables do not share the same headers.

Your task is to:
• Extract every table accurately from each WPS document.
• Map or append the differing headers so no information is lost; if a column appears in only some files, create the column and leave blanks where the value is missing.
• Preserve original formatting where it helps readability, but the priority is clean, usable data (no merged cells, unwanted line breaks, or stray styles).

Deliverable: one .xlsx file containing a consolidated table that I can filter and sort immediately. A short note explaining any header choices or assumptions you made will help me verify the import.

Thanks.