excel - Loop through visible worksheets and refresh all hidden Pivot tables -

i have dedicated computer , tv screen both purpose of showing sales figures entire business see.

i have spreadsheet 3 visible worksheets "sales day", "sales month" , "sales year". these worksheets linked hidden pivot tables in same workbook.

can kindly design macro loops through worksheets after 30 second intervals. tricky part pivot tables in workbook should refresh after every 30 minutes.

the refreshing should make short break in changing of worksheets loop, after refreshing done loop should continue way was.

please assistance highly appreciated , send picture of how master piece look.

the loop code have below...

sub test()   dim long, t single    on error goto exit_   application.enablecancelkey = xlerrorhandler       = + 1     if > 3 = 1     if = 1     sheets("sales day").select     elseif = 1     sheets("sales yesterday").select     elseif = 2     sheets("sales month").select     elseif = 3     sheets("sales year").select     end if     t = timer + 1     application.wait + timeserial(0, 0, 30)     if timer < t exit   loop exit_:  end sub