I have a workbook with 4 sheets to keep track of membership in an organization. Each sheet represents a different membership category, and all sheets contain about 20 columns of data on each member.



I need to create a 5th sheet that has only the members' names and a third column with their current status. This fifth sheet should contain all members from all of the 4 sheets. It also needs to be sorted by name, and a 4th column added to be a sequential number, starting at 1, for each member.

And finally, all this needs to be dynamic - so that if a new member is added to any of the 4 sheets, or any status changes are made to the 4 sheets, this 5th sheet will be automatically updated, sorted, and the sequence numbers regenerated.

Is this at all possible? (prefer a solution without VB which I am not familiar with )