Need your knowledge - vlookup with dynamic sheet reference VBA

Hi there !

I come here and request your knowledge :

I'm beginner with VBA, I wrote a code and here is the main part where i'm blocked :

Please Login or Register  to view this content.

[/U][/B]

The part where i'm blocked is the last part, the vlookup formula.
What i want my code to do is quite simple :
it create each time 5 tab one called Ledger and the others with the name of our member's team, and add a variable (which is here today's date, each time you run the code).
It copy and paste data from another sheet, and then copy and paste those data to each member sheet, using the clerk number as a filter for each member ( in my code, i've only wrote the code for member no 3)
This code is supposed to be run regularly, with 5 sheet created each time (in the same order), and i would like to bring comments from the previous run to the new tab using vlookup, for each tab.
I looked for many clues on the internet, but could only find Activesheet.Previous.Name (in red), but it works only on the previous worksheet. I need a vlookup based on the emplacement of the tab/sheet but minus 5 - the 5th previous sheet ( am i clear ? :x), and this for each sheet.

Maybe this screen below could be more explicit for you:
Exemple.PNG

I tried Count and Index, but it doesn't work. But also i'm not sure to know how to insert them in the vlookup formula...
What should i replace ActiveSheet.Previous.Name with ?

Any clues ?

Thanks for your help and sorry if i'm not very clear
Kenken1987