I have a worksheet that I would like to rename the "Sheet1" tab with an assigned name from a field (ie. B1). This name will then be pulled to a summary sheet to update a summary page with data from the assigned worksheet. How can I accomplish this task in excel. Thanks.