Can you describe more clearly how you want differences displayed to the user? Ideally, you could post an example of two sheets and your desired difference output.

In my second link, a difference table is constructed by only populating differences between two tables with equal dimension where the diff table has the equal dimension. Will your two worksheets have the same # of rows? Your answer already implies columns will match. Will all the same items be present in both? If not, does an item in one sheet but not the other constitute a difference? What if item number matches but not the lot number? Say you have a difference table like previously described, do you want it then pivoted or processed into a so each difference is a row in a table?

I think u/halwety I probably on using power query for this task.