My First Macro Task - Please Help

[harjit]

I have an excel spreadsheet which I need to write macro for. The followings is what I need to do
For every new spreadsheet, it should have
1) the header
2) the legion
3) data (different data according to customer codes, so if there are 12 customer codes i'll have 12 different spreadsheets,the only similarity will be the header and legion.)
I need to copy paste all this in a newspreadsheet and save it according to different customer codes.Im not suppose to hard code the location (rows,columns) since the location of data keeps changing from time to time.
Does anyone have any idea how I can go about with this? If there's any examples I can look into,please do forward it to me.Would really appreciate it.Please help as this is my first macro task. Thank you so much.