Thanks for your quick response watersev! I tested the macro by adding & changing the price of items and it worked perfectly fine.

However, when I tried removing an existing item in the "New Items" sheet (for example: Mobile Phone) & then run the macro, the "Items Removed" sheet shows the summary (which also appears in the "Summary" sheet) instead of showing the list of items removed. Can you fix this? Apart from this, I think everything else works like a charm. Thanks!