Getting data from a huge table to a smaller and organized one.

I have this table with some information that I need to work with. The data is simple, but it has many issues, at least for me, to be able to work with it properly.

Basically, I just need to transfer part of the data from this table to another table (in another order). I failed to use vlookup because I need more than one parameter to search the data (Date, Shift and Sector). Maybe it is silly for experienced users like you guys, but my mind is blown already.... I tried everything I could search/think of.

The problem I am having to get the codes from the source table is that the same code sometimes shows up more than once per date, per shift and per sector. It's also not following a numeric pattern. I couldn't elaborate any combination of formulas to get the info I need.... I am very frustrated right now

I also can't change the format of the source table, because I'm not the one who made it, it has years already, and is constantly updated day by day by a good old man who doesn't know much about computers.


The file is attached, if you need any other information I'll be here.

Thank you already, and sorry for the trouble

Hi
If we look at the values in the Worksheet sheet in cells A3 and B3 there are multiple occurrences of these values in the Source worksheet so how do we know which value to pickup?
Tony

Yes, that's my major problem. The worksheet has the Date, Shift and Sector defined, I need to get all the codes that match these criteria in the respective cell. But sometimes I get more than one code for the same Day/Shift/Sector. I don't know how to separate these.

Hi
We need to understand the logic for separation before we can help you automate it.
If you were doing it manually what would your logic be?
Tony