joining data from different columns in different sheets into same columns in one sheet

Hello,

I'm trying to figure out how to get data from different sheets(Sheet1, Sheet2, ...) with a same column name(numeric) into 1 column in the "results" sheet.
Cell values could be double(sheet2) and columns empty(Sheet3). Cell values in the result sheet should be unique

This would help me very much, so i'm really looking forward to this code ;-)
Thanks !!

Thanks for the fast reaction Mumps1 !

This code works perfect