I have between ten and fifty Excel workbooks, all laid out with identical columns and formats. I now need every record merged into a single, clean spreadsheet that I can use as a lightweight database for reporting and analysis. Your task is simple but accuracy-critical: pull the data from each source file, append it row by row into one master worksheet, and preserve every column exactly as it appears in the originals. While you work, please watch for blank rows, obvious typos, or duplicated entries and let me know if anything unusual turns up. The final deliverable is one Excel file containing every consolidated row, ready for filtering, pivoting, and future SQL import. If you prefer Power Query, VBA, Python (pandas), or another reliable method, that’s fine—what matters is a spotless, fully combined sheet. Once delivered I’ll test a few random samples and confirm row counts match the originals before sign-off. The data needs to be analyst with potentially creating a PowerBI Dashboard for quick data insights