Data Alignment and Reconciliation

I have data on multiple spreadsheets that I am trying to reconcile across those same spreadsheet. References exist in varying formats. Significant alignment is required to identify where common data exists across the spreadsheet. The context is an audit which has identified 1000's of missing parts. Several spreadsheets have been provided to identify where the parts are or have gone.