On the attached sheet, I would like to create a tab for every broker seen when you filter columnA (and name it each respective broker name). So on the attached, after Sheet1, it is possible to use a vba code to read what is filtered in A (in this case JP, AAM, CITI) and rename three tabs after each of the broker? I went ahead and renamed the tabs on the attached so you could see the desired results. Is this possible using a VBA code?