VBA copy from active worksheet not set worksheet

[namluke]

Hi, I have part of a code below that copies data from the worksheet depending on the worksheet name within these symbols "", is there a way to have it so you don't need to have the sheet name and you can just copy from what ever work sheet you are currently viewing?

Please Login or Register  to view this content.

[xlbiznes]

that would be something like this :

Please Login or Register  to view this content.