Dynamic Sheet Name in Vlookup/Sum If Formula

[Kaustubh1040]

Hello Friends

I need a help to set the worksheet name to dynamic. Currently the below vba code is working properly (assuming the name of the worksheet is 'Sheet1'). I want to make it dynamic may be using Worksheets(1).Name in it.
But, I don't know how to do it. Please help.

Please Login or Register  to view this content.

[WideBoyDixon]

Like this perhaps?

Please Login or Register  to view this content.

WBD

[Kaustubh1040]

Thanks, Working now.