Combine (filtered) data from 2 sheets in 1 sheet

[Sportman1975]

Hi All,

I guess it's just a piece of cake for some of you. But this is my challenge and I don't know how to start/solve it.

File 1: ExportAP.csv (contains list of invoices-accounts payable)
File 2: ExportAR.csv (contains list of invoices-accounts receivable)
File 3: Calculation
In files 1+2 column L contains client number and column M client name.

All the files are on C:\temp\settlements\

File 3 contains a worksheet (name: Masterfile)which contains client numbers (column A) and client names (column B) =(unique list of course)


Step 1:
Now I copy File 1 and File 2 into file 3 as separate worksheet.
Can Macro pick up these two files and import them both into the file Calculation? (File 1 and 2 are also in the map C:\temp\settlements\)
File 1---> worksheet name in Calculation: specification creditors
File 2---> worksheet name in Calculation: specification debtors

Step 2:
For All the clients which are in file 3 worksheet Masterfile I want a new file made which contains the following format:
Line 1: Client number: [generated by macro of course]
Line 2: Client name: [generated by macro of course]
Line 3: Date from worksheet input (File 3(=Calculation)field=B3
Line 4: empty
Line 5: empty
Line 6: Text--> specification debtors [bold][italian]
Line 7: Empty
Line 8: Column headers [generated by macro of course from specification debtors=line1]
Line 8-.... Lines containing data from specification debtors]

Line....+1: empty
Line....+2: empty
Line....+3: Text--> specification creditors [bold][italian]
Line....+4: Column headers [generated by macro of course from specification creditors=line 1]
Line +5-.... Lines containing data from specification creditors]

I understand it's hard to follow. But I really need this file......Can someone help me with this?

 

[Sportman1975]

Really nobody who can help me out?