Car Example
There is a list of components used in the assembly of a car along with the quantity of each component used. The car got new snow tires and a different version of a drive shaft. So the component list changed and so did the quantity of certain components such as bolts. I am left with two lists. One that correlates to the old car and one that correlates to the new car.

I want to be able to copy and paste the list of old components into a column, the list of old quantities right next to it and then do the same with the new list on the same excel sheet. I then want to copy this information to a different sheet which will then compare the two lists. I want to know what components were omitted and added along with changes to the quantity of a part used.

Is this possible?

Note:
I have multiple cars and want to be able to do this with each car when each changes. So I want to be able to copy of the data from the first sheet to the second sheet only if there is a value in that box. So maybe have a loop start at a certain point in a column and cycle down the column until I don't have anymore values.

I know it's a lot of information but I just need a little guidance. This is being used for a project at work that does not have anything to do with cars...just an example.

Thank you