Currently what this code does is check Column C value in 'Master' sheet and will copy over to matching worksheet name.
I would like to improve on this code using sort of lookup feature.
I have this new table
<tbody>
ColA
ColB
ID1
East
ID2
West
ID3
North
</tbody>
If Column C match the...