Excel spreadsheet data entry

Hello, 

I have had to re-type multiple spreadsheets in Excel due to when opening the spreadsheets I need they appear corrupt, jumbled, data is scattered. I'm trying to avoid re-typing as I've been forced to do. All the solutions I'm finding are very, very tedious. Any suggestions are helpful. 

I've tried converting it, copy/pasting different ways, formatting different ways. No luck. Even copy/pasting from PDF which I also have of the data & it pastes very incorrectly & unreadable. HELP!? Thank you!