Excel Mixed Data Entry

I have a collection of research records already sitting in a single Excel workbook. Each row combines numbers and text—participant IDs, dates, measurement values, short comments, etc.—but the columns are inconsistent and several sheets need to be merged into one clean, well-structured master file... (Budget: $10 - $30 AUD, Jobs: Data Analysis, Data Entry, Data Processing, Data Scraping, Excel, Excel Macros, Google Sheets, Visual Basic)