Hi,
I have Four work Books. Three are contain the data and one is to link
those datas from those three work books. Examples.

WorkBook #1. In cell A1 has customer name
A2 has total amount.

WorkBook #2. In cell A1 has customer name
A2 has total amount.

WorkBook #3. In cell A1 has customer name
A2 has total amount.

WorkBook # 4 will link those workbook #1,2,3's Customer name and the total
amount.

But, if some of the workbook doesn't have the customer name and amount. I
don't want it to show on the workbook #4 and not even the empty space. How do
I write the code for this.

Any help would be very appreciated.