Hi Dmoney I figure out, just modify your code Thank you very much

Dim workbooktab As String
workbooktab = Range("b14").Value
Worksheets(workbooktab).Select

"dmoney" wrote:

you can assign the value of cell B14 to a variable and use the variable to
select the appropriate tab.

dim tab as string
tab=range("b14").value
worksheets(tab).select


HTH

dmoney

"Eduardo" wrote:

Hi everybody, I hope you can help me with this one. I have a Pivot table
where I have a macro that update my invoicing information from an external
data. So every month I run that macro to have the sales of the previous
month. The month in the PV is in cell B14. In the same worksheet I have
different tabs for each month where I copy the information as values in order
to create a Summary of sales. What I need to do is once the macro is run and
the month show up in cell B14 is go to the corresponding tab i.e. Aug. Thank
you in advance