No worries. I asked because you mentioned OCR which implies images but you also say select all works which implies it is text.
I will now assume it is text.

You could look into xpdf(pdftotext) to batch convert them to text, then combine the said text files into one and then copy paste it to excel.

Assuming you are on windows it would work like: forfiles /M *.pdf /C "cmd /c pdftotext.exe -table @fname.pdf @fname.txt"

here /M is the search mask, /C is the command to perform on every file.

then you just combine all the files using copy *.txt all_pdfs.txt

then you can copy paste from this.

Hope it works.

P.S. There must be more efficient ways to do this, I am merely presenting what I know.