|To help clarify things|
When info is copied from workbook1 B3:CU99, what sheet is it coming from.
When info comes from workbook1 it is placed on sheet3 to the master workbook sheet 3 B1:CT6 (is it really CT or CU)?
When info comes from from workbook2 and so on to workbook 10, where does each of the numbered workbooks need to paste its data?
I sounded like you ran an already developed macro AFTER the copy and paste of all 10 workbooks was complete.
This is all very "doable", its just a matter of being a little more precise of with the references to where data is coming from and where data is going to. It helps the VBA programers immensly since they can't see your work book or read your mind to fill in missing info.
I unfortunately cannot help with VBA (Macro btw) but I know what the experts here will need to a degree.
I hope this helps.