Thanks. I found the way to name the worksheet tabs by setting the page break expression.
The problem now is is the column headers do not show on each page although i have the tablix property for column headers to repeat across each page in report builder 3.0. Any ideas?