If anyone can help, it would be greatly appreciated.

I have two spread sheets. One of them holds employee information and
statistics. The format is listed below:

Workbook1.sheet1 (these cells run B9:L9, then B10:L10 etc..)

Firstname,Lastname 87817 22 16:12 112:16 14:44 104:12 0 0:00 587:53 0:00

I have another sheet, the format is listed below:

Workbook2.sheet1 (these cells run from A4:J4, then A5:J5 etc..)

Firstname Lastname Supname


I have to create a new sheet based off of information gathered from both
workbooks. I need everything from workbook one, with the addition of the
Supname from Workbook2. The final data for workbook3 will look like this:

Supname Firstname,Lastname 87817 22 16:12 112:16 14:44 104:12 0 0:00 587:53 0:00

Then I need to take that information in workbook3 and have a new tab create
for each supname, and listed on each tab the employees for that particular
supname.