Hello. I have multiple sheets which are all consolidated in one sheet. Now i want to add some more data to some sheets. Each entry is with a unique ID which is in increasing order. i want a macro that would look for ID in individual sheets and if a particular entry is not in compiled sheet then copy that row and paste it according to serial number in compiled sheet. So for example if ID '4' and '6' are already there in compliled sheeet with no rows empty in between.Now if i add any data in column next to ID 5 in individual sheets, I want the macro to add two rows after ID 4 compiled sheet and copy entire rows containing ID 5. ID appears in column F in all sheets. Please help.