I have three seperate spreadsheets with some common data on them. Each
spreadsheet contains an employee's name, check number and check date.
Sheet 1 has one row of data for each unique employee name/check
date/check number combination but the other two sheets have multiple
rows of data for each unique employee name/check date/check number
combination.

Sample Data
Sheet 1:
Name Check # Check Date Gross Pay Total Ded Total Tax Net
Pay
John Doe 210356 2005-10-07 20.00 7.00 3.00
10.00

Sheet 2: (First three columns are the same as Sheet 1)
Name Check # Check Date Ded Type Ded Code Ded Class
Current Ded
John Doe 210356 2005-10-07 Life LFE01 EE Portion
1.00
John Doe 210356 2005-10-07 Health HLTH4 EE Portion
1.00
John Doe 210356 2005-10-07 Health HLTH4 ER Portion
1.00
John Doe 210356 2005-10-07 Retirement RET03 EE Portion
1.50
John Doe 210356 2005-10-07 Retirement RET03 ER Portion
2.50

Sheet 3: (First three columns are the same as Sheet 1)
Name Check # Check Date Tax Class State Current Tax
John Doe 210356 2005-10-07 FICA/EE US 0.50
John Doe 210356 2005-10-07 FICA/ER US 0.50
John Doe 210356 2005-10-07 Withholding US 1.00
John Doe 210356 2005-10-07 Withholding LA 1.00


I need to combine the three spreadsheets into one as follows...

Name Check# Check Date Gross Pay Total Ded. Total Tax Net Pay
Life Health-EE Health-ER Retirement-EE Retirement-ER FICA-EE
FICA-ER Withholding-US Withholding-LA

John Doe 210356 2005-10-07 20.00 7.00 3.00 10.00
1.00 1.00 1.00 1.50 2.50 0.50
0.50 1.00 1.00


Is this even possible, if so can someone help me out with this because
I am new to macros and I have no clue where to begin.

Thanks in advance!
Gerald