Checking values in different sheets and paste if existing in new cell

[MattiasK]

Hi,

I have a document with different sheets named year (215,2016, etc). Each sheetcontain data from car manufacturers.

Fo example:

Sheet A (2015)
AUDI
BMW
Toyota
Ford
Volvo
Volvo

Sheet B (2016)
BMW
Citroen
BMW
BMW
AUDI




In each sheet, a manufacturer can be stated several times. I need to getdata that the manufacturer is in the list. The result would look like:



Sheet C(Overview)
BMW
Toyota
Citroen
BMW
AUDI
Ford
Volvo


As you can see,Citroen was only in sheet B and Toyota in sheet A but in the overview I know itis used un-dependent on what sheet it is in. Others were stated several times in different sheets.




Thanks.




/M