Hey All,

I am trying to create a Macro which will Copy all Comments made on sheets "Active", 'Precon", "Pending", and "Complete" to a master sheet "All".

Basically I need all the comments from these four sheets in the range C3:BN101 to appear in the "All" sheet from C2:BN101 and for this to update whenever "All" is made the active sheet. In order to avoid conflicts, I would also need all comments in "All" first deleted as comment locations may shift and I would like to avoid duplicates.

I have no knowledge of VBA and everything that I have tried from similar examples I have found has failed so any direction would be greatly appreciated.