Need Help! Formula for repetitive code

[vikixp2003]

Hi, I need a formula where i have a repetitive code (10 digit) in 15 different sheets and want to bring all code in one common sheet with no duplicate/omission of codes. please dont say copy, paste the data and do duplicate. The data is huge i will simply paste the data in new sheet and automatically the data should scan the sheet and recall the code to main sheet if any new code found. Please help me in solving this. Thank you in advance.​

 

[alansidman]

Show us some sample data. Are all sheets organized in the same manner. Also show us what the end result should look like. It helps to be able to visualize.