Combine data to fixed product id
 

Need a worksheet in excel which will combine data from different worksheets ,

Example Sales by month

Product Jan Feb March
ab-1000 100 129 140
ab-2000 50 20 30
ab-3000 40 10 50

Combine data to fixed product id
 

You could try using a pivot table and using the multiple consolidation
ranges option.