Need a Excel or Google Spreadsheet macro to compare imported data to existing data

General information for the business: we build things
Industry: Art and Design
Description of excel work: Currently using a home grown formula to compare a set of data in one tab vs another, a third tab runs a formula to compare if the data has been changed. The formula works but is "finicky". It can not take into account if a data set has been added or deleted, so all cells need to be shifted and the formula repopulated. We need a better way to create this "change report"
Design and target audience: would like to have a clean user interface with instructions and have buttons to run function and generate report
Extra notes: I am happy to share the excel file to demonstrate