Perhaps a sample workbook would help. I'm not picturing how those three bits of data, with every person on their own line, needs 26 tabs. Are the lengths of the tables different on the various tabs?