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
1235 $50 $25 1235 $65
$20
7858 $75 $31 7858 $75
$31
2538 $40 $46 2538 $41
$74

After consolidated:
under workbook #1
colum A colum B Colum C(show data from colum B under workbook#2 )
1235 $50 $65
7858 $75 $75
2538 $40 $41

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