hi & good evening.
i have a worksheet that on a weekly basis needs the tab changed but will always have the same text after it IE
This bit changes weekly-This bit never changes
This bit changes weekly would use the info in cell D1
very much appreciate your help.