Copy Row contents from one worksheet to another specific worksheet using Worksheet_Change

I would like copy the values of the cells "A" to "G" in a row from a worksheet called "Log Entry" to a separate worksheet with a name that matches cell "A" and paste it to the next blank row. I already have code that is actioned by worksheet change for other stuff. How do I refer to a worksheet name based on value just entered in a specific cell?

Please Login or Register  to view this content.