Copy data into another sheet



I have 15 different sheets which contains data on orders. All the orders has the same ID across different sheets. I want to create one master sheet with all the data that's available on the 15 sheets based on the order ID. I have been trying to use report and but it doesnt quite work. Any suggestions?