Facing Problem with VBA Excel on Pulling data

Hi All,

I am working on, I have a data in different worksheet that is CHGBW, CHGBRW, REPRW, STAR, PULSE, and NYCE

I have data in all these sheet

I also have a sheet in the same workbook with the name DSMT_Procssing_LOG

I need to create a macro in DSMT_Procssing_LOG, which will help me which will pull the data one by one in the required cell on basis of the heading on the data

I want the data to get pull on basis sheet
And I have a cell that is D6 with a drop down containing all the same of the worksheet (above mentioned)

Please help

Attached is the file for reference

Thank you