View Single Post
  #1   Report Post  
JG_HILL
 
Posts: n/a
Default print report with data from specific worksheet

I have a workbook with multiple sheets. The first sheet contains a report
that I need to print using data from a specific sheet that changes each
month. For example, the report for January needs to pull data from the sheet
named Jan. When it's June the report needs to pull data from the June sheet.
Since I know the date how can I automate getting data from the correct sheet?