Copy Rows to different sheets VBA Macro IF cell value matches to sheet name

  • Hi,

    I have 3 different sheet as attached.

    In sheet Employee List, when i input any of the days for eg "Sun" in to column D2, then the data from sheet June need to copy from range A3:G3 and paste in sheet PCplant at A5:G36.