With your Tablix selected, you will see an option “Page Name” in the properties menu. Insert the name you’d like this tab to have once exported to Excel. This can be done for all tables/objects in your report. Be sure to add a Page Break after each item you wish to split to a new sheet.
To enable the Properties window:
Results in Excel:
Click to edit your new post…