Collating data

[Nova1979]

Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without doubling up data. These are 9 digit numbers and some are on the same sheet multiple time and also across multiple sheets ie on sheet3, sheet4, sheet7 but I need it to show only once on the master sheet

On top of this is it possible to have it numerical? Or might this be too much and just easier to sort?

Thanks in advance.

 

[Nova1979]

I can only work with what I have.
Would you happen to know a formula for my current Issue?

 

[sandy666]

sure, have a nice day

 

[Nova1979]

Still trying to find suitable formula. Problem is unresolved

 

[Fluff]

Re-posted Index formula help