VBE - Go to tab related to formula/day

[guilli_003]

Hi,
I am not great with VBE, but I’m trying to create a “simple” code for my work that does the following:
I have a main workbook with many different sheets called:”Mon – French Prod; Mon – Intern. Prod; Mon – Subs. Prod; Tue – French Prod; Tue – Intern. Prod …” and so on with all the days of the week.
I have 3 secondary workbooks called Book1, Book2, Book3 and I need the last sheet of each to be past for example Book1 will go to “French Prod, Book2 to “Intern. Prod” and Book3 to “Subs. Prod”.
Until there it’s okay, but I want it be paste under the following excel code: “=TEXT(TODAY()-1,"ddd")&" "&"-"&" "&"French Prod"”.
So let’s say we are on Friday and I press my macro from the “Book2”, I want it to paste the last tab of it in the main workbook in the tab called: “Thu – Intern. Prod”.
I hope I’m being clear enough…
Thanks in advance for your help as always!
Kind Regards,
Guillaume Van Aelst

 

[guilli_003]

Hi,

To simplify let's say that I would just like a macro that leads me to the sheet of the current workbook through that formula: =TEXT(TODAY()-1,"ddd")&""&"-"&" "&"French Prod"...

Is it possible?

Thanks in advance for your help.