Copy typing

I'd like to discuss a job that involves the analysis of data across multiple spreadsheets. The spreadsheets are in different formats (some in Excel, others in WORD or PDF), the fields and data are not always the same, and the data in each may posted differently (for example, last name, and first name may be in the same cell or two cells, etc