So you've got multiple people sending you spreadsheets of data? Does each spreadsheet have nuanced differences that you have to fix? Do you get these spreadsheets regularly? Then you need to take a look at Intricity's Data Validation Factory.
Talk with a Specialist: intricity.com/intricity101