VBA to consolidate multiple worksheets to 1 worksheet in running sequence

[chongchingsoo]

I have a workbook named Small Workbook with 3 worksheets. Thos
worksheets named Sheet 1, Sheet 2, and Sheet 3.

All the worksheets have the same format, and are in the followin
manner:-

Column A = Date
Column B = Number
Column C = Particulars
Column D = Amount

I need to consolidate all the above Information into another workboo
called Big Workbook and it has only 1 worksheet named Sheet Bigger.

The Sheet Bigger is presented in the following manner.
Column A = Date
Column B = Number
Column C = Particulars
Column D = Amount from Sheet 1
Column E = Amount from Sheet 2
Column F = Amount from Sheet 3

I would like to know whether VBA can directly update data from Smal
Workbook to Sheet Bigger in Big workbook in a running sequence of date
Also, without any formula included in the Big workbook.

Illustration:
In Small Workbook
Sheet 1, Cell A2 = 1/1/2004, Cell B2=123456, Cell C2=BMW, Cell D
=$5.00
Sheet 2, Cell A2 = 4/1/2004, Cell B2=222222, Cell C2=PORCHA, Cell D
=$1.00
Sheet 3, Cell A2 = 2/1/2004, Cell B2=654321, Cell C2=A&W, Cell D
=$3.50

In Big Workbook
Cell A2 = 1/1/2004, Cell B2=123456, Cell C2=BMW, Cell D2 =$5.00
Cell A4= 4/1/2004, Cell B4=222222, Cell C4=PORCHA, Cell E4 =$1.00
Cell A3 = 2/1/2004, Cell B3=654321, Cell C3=A&W, Cell F3 =$3.50

For Big workbook sorting sequence based on DATE.

Please advice.

Thank u.


Susa

 

[Guest]

hi,
do all of the file hav the same number of rows.
do the files contain duplicat data.