Copy from multiple workbooks to one work book.

[alimmv]

Hi,

I have multiple excel sheets with information about daily invoices that need to be copied to a master creditors file only if that invoice is not paid. In that file we record the daily collection details also. So if it is under the heading of Credit collection, then those invoice numbers should be deleted from the master credits file. Below is a sample of how the excel file. If you want I can attach a dummy file.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date:[/TD]
[TD]12-12-1990[/TD]
[TD][/TD]
[TD]Payment Details[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice No.[/TD]
[TD]Customer name[/TD]
[TD]Amount[/TD]
[TD]Pmnt Dtls[/TD]
[TD]Pymnt dtls[/TD]
[TD]Pymnt dtls[/TD]
[TD]pymnt dtls[/TD]
[TD]Paid[/TD]
[TD]Credit[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Example Customer[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Ex customer 2[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Ex
customer[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]100[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Credit Collection[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Ex customer[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]250[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Now I understand that this might become very complex so if you can help me with the copying of only the daily credit invoices that would be also very good.

Thanks in advance