Sorry I couldn't think of a shorter title that would be descriptive enough.

I've got a workbook with 5 worksheets. Three of them contain exactly the same data, just arranged differently. i.e. First sheet is sorted by last name, second sheet is sorted by state and third is sorted by birthday. The 4th and 5th sheets only show a small number of entries from the first three. Every month the workbook is saved as a PDF to be sent out to the members of the club. The data entry worksheet is the 1st, By Last Name sheet, which has 12 columns of info on each member. All of this information is duplicated on the other 2 with the exact same date just arranged differently. I've been copying and pasting and I've tried recreating the other worksheets after the By Last Name changes are made. But, two methods are time consuming.

Is there a way to link the twelve columns on By Last Name to the State and Birthday sheets? It should be noted that the State and Birthday sheets have a blank column between items. i.e. Arkansas, blank, Alabama and January, blank, February.

Thank you in advance,
Hozey