order info worksheet

hi there
con anyone help
I have a window manufacturing company
what I require is a to have a worksheet /spreadsheet for each order so the info from the order (sizes, options etc) on say sheet 1
so that I can have a calculating sheet on sheet 2 to produce a detailed component cutting list and spec sheet
what I am doing at the moment is copy and pating the info into a spreadsheet but requires a long macro to weed out the order of data
hope this is possible
thanks
blair