I have 2 seperate workbook each workbook contains certain numbers and $
amount. Here is how I want to result:

before consolidate:
workbook #1 Workbook#2
colum A Colum B Colum C Colum A Colum B Colum C
1259 $50 $75 2589 $51
$69
3597 $49 $82 1259 $50
$76
2589 $54 $70 4582 $58
$12

After consolidated:
under workbook #1
colum A colum B Colum C(show data from colum B under workbook#2
)1259 $50 $50
2589 $54 $51


and colum C from workbook#1 may show in colum D
and colum C from workbook #2
may show in colum E in workbook after consolidated.
How do I do this??
thank you in advance