How to develop a macros to auto copy and save data on series basis to another sheet

Hi Friends,
I have made one sheet for retails for billing in which I have made one button which will print the sheet and will also save it automatically but there are two more commands that I wanna develop in it & that is the names & the numbers of the customer that are taken during the billing should also move to the different sheet and should get saved in front of respective bill no & on the same sheet where the cell that contains bill no. a new bill no. should appears from the series.

For more clarity I have attached an excel file and its snap shotProblem Sheet.png.

Please help..

Thanks in advance.