I am using the below code to copy data from a sheet to different sheets if the sheet name matches with text of column E
Sub CopyToSheets()
Dim ws As Worksheet
Dim ws2 As Worksheet
Dim lastrow As Long
Dim lastrow2 As Long
Dim rownum As Long
Dim ws2name As String
Set ws = Sheets("RAW DATA")...