Auto list into cell based on reference sheet

Hello everyone,

I got an issue which annoy myself.
I would like to ba able to be able to list into differents sheets something like a dropDown (or comboBox)
some data in order to take them into another sheet.
I did it, but I can't do it when in my column type(sheet data), differents types are mixed.
I think that I may classify it, and then make appear the serial in order to the type (sheet)

Do you have guys any advice to help me?

I attached List.xlsx the files, like that you could have a better view!

Many thanks