Excel Text Data Entry

I have a collection of Excel files that contain purely textual information. I need every record transferred into a single master workbook, keeping the existing column structure and formatting consistent across all sheets... (Budget: ₹750 - ₹1250 INR, Jobs: Data Analysis, Data Annotation, Data Cleansing, Data Entry, Data Management, Data Processing, Excel, Visual Basic)