I am currently building out a risk/issue log for clients for my job. Each client has an individual worksheet and I have a log worksheet as well. The client worksheets contain a risk/issue section that I need to archive over time. New items can be added and other items can be modified on each worksheet. I need to create a VBA macro to run through all of the worksheets and search for new items or updated items within each risk/issue section. If there are changed items or new items I would like the updated items to update on the log and any new items to be added to the log. I am having issues figuring out how to copy and paste only new values to the log. Can someone help?