Create new data set based on critera

This is a difficult question to explain but i'll do my best.
From the data set on sheet1 i would like to include the following on sheet2. The first 4 columns are not necessary. In column A with a heading of "Material" the material number as it is. Column B with a heading of "Serial Number" also would have the serial number unchanged. Column C under a heading of "Sold to Store" would have the "Posting Date" from sheet1 if Plant is >6000 and SLOC is 33 else leave it blank. Column D with a heading of "Returned to Store" would include the "Posting Date" if Plant is >6000 and SLOC is 26 else leave it blank. Column E with a heading of "Received at UTI" would have the "Posting Date" if Plant = 1222 and SLOC = 33. If there was a duplicate then the most current date would be used. Column F with a heading of "UTI WIP" would have "Posting Date" if Plant = 1224 and SLOC = 158. Column G with heading "UTI Prescreen" would include the "Posting Date" if Plant = 1222 and SLOC = 130 or 89 or 94. And finally column H with heading "ASC Refurb" would have the "Posting Date" if Plant = 1224 and SLOC = 94 or 123 or 85. Hopefully with the attached workbook this makes sense.

Thank you in advance.

Sample.xlsx

Thanks allot Pierre this is just what is was looking for. By the way we share the same last name. Thought that was ironic!