In the top menu of Excel select Data > Get Data > From File > From PDF. Browse your files and select the PDF with the table ...
With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...