I have a requirement to copy employees based on their
names from one worksheet to other worksheets. The criteria
would be to find their matching names and copy the
adjacent rows of information as well. The new worksheet
should be populted based on the date entry. Since there
are more than 20 employees listed in a random order there
should be a sorting by date and entering to the new
worksheet in the same order.

Anyone having a solution via VB or macro would be
appreciated.