In Acrobat: Tools - Forms - More Form Options - Merge Data Files into Spreadsheet...
You should not merge those files into a single PDF, though, as that will remove all of the date in all of them except for the first one.
If you want to merge them you have to first flatten them.
It didn't quite work.
On each form there could be more than one name. So Row 1 has info client Bob. Row 2 has info on client Carol, etc. When I export the data. Carol's info shows up in the same row as Bob's, I would want her info to show up in a new row. Any thoughts?
That would require a custom-made script and Action to implement in Acrobat (Pro), or you could do it using a Macro or something like that in Excel.