Struggling to work with PDF data in Excel, feel like I’m missing something obvious

I keep running into the same issue at work where I’m given PDFs and need to get the data into Excel in a clean, usable way, and it’s turning into a time sink. I’ve tried importing, copying tables, and a few workarounds, but the formatting always comes in messy or breaks as soon as I try to use formulas. At this point it feels like I’m fighting Excel instead of using it, so I wanted to ask how others usually handle this before I go even further down the rabbit hole.