Generate new sheet from other data sheet and summary sheet

hi,

i am making a macro regarding generate 4th sheet which is sort name of all customer A-Z. This 4th Sheet generate from pick name from sheet 1 ( Summary - Customer name ) and take data from sheet 2 ( Sales Data Sheet ) and ( Collection Data Sheet ).

Just think We have 1 sheet is list of ( Column A - S.No.,Column B -Customer name like 100 names and Column C - Address, Column D - Mobile No........

and 2 Sheet ( Sales Data Sheet ) contains record of Transaction ( Column A - Sales Date, Column B - Customer Name ( Unsorted ) , Column C - Product Sales Amount.

and 3 Sheet ( Collection Data Sheet ) contains record of Transaction ( Column A - Collection Received Date, Column B - Customer Name ( Unsorted - it is same likes Sheet 2 Customer Names ) , Column C - Collection Amount (against Product Sales amount / Advance) .

So macro will generate the 4th sheet like ( Column A - Sales Date, Column B - Customer Name ( sorted A - Z and highlights with Yellow colours) , Column C - Product Sales Amount , Column D - Collection Received Date , Column E - Collection Received Amount , Column F - Breaking of Collection against Sales Amount on FIFO SYSTEM like adjustment against Product Sales amount - ( like collection break against first sales amount and run the process FIFO SYSTEM -FIRST IN FIRST OUT BASIS , Column G - Difference day between Product Sales amount Vs. Breaking Collection ( Column F)..... That is only........

Dear All, before making that macro, you need to do manual that process, and adjust collection amount from first Product sales amount and calculate the days and also think more about format and if any customer is give only advance, then how it show in new generate 4th sheet, you have to think more when you will do manual that process and found the all point for making that macro.

I hope you understand my point.

any person helps about this thread

Any person have any VB code for this thread