Routine Work Automated

[lucky_2say]

Help needed!! I'm new to Excel Programming.. I am working in a customer service dept so my routine work is pretty massive but relatively easy.. I have to scan barcodes (25+ digits) in their respective categories which means a couple of workbooks and since its daily routine the workbooks are further categorized..
so what i want is.. if there's anyway that i could do all that work in a single sheet so excel may save today's work in a seperate workbook named as today's date keeping the 1st row and column same as first row is the header and 1st column is the serial number of the scanned packet.
i'll provide you further details and even an attachment of a file if you need it to solve the problem.. Thanks in advance..

[watersev]

hi, lucky_2say, let's give it a try, please post sample workbook showing original data and result you need to obtain