I'd start by opening the pdf in Word, which would likely preserve the formatting of the tables and then, assuming that the pdf tables were rendered as Word tables, use VBA to iterate them and copy them into an Excel worksheet.