Copy , Insert rows and Paste data from two sheets to third sheet

I have data in two sheets one sheet having customer and another having material data. In both sheets, unique column in Base Cust. In customer sheet, each Base cust has 1 or more different customers and material sheet has same like each Base cust has different materials. I want to consolidate both sheets data in new sheet.

For example -

Sheet1 has following data

Base cust customer

00301 112501
00301 112502
00302 112503
00302 112504
Sheet 2 has following data

Base Cust Material

00301 M12113501
00301 M12113502
00302 M12113501
00302 M12113502
In New sheet data should looks like

Base Cust Cust Material

00301 112501 M12113501
00301 112501 M12113502
00301 112502 M12113501
00301 112502 M12113502
00302 112503 M12113501
00302 112503 M12113502
00302 112504 M12113501
00302 112504 M12113502
I need your help if you can provide me VBA codes to prepare this kind of above data.

Thanks.

Narendra

Hello

Thanks for providing codes. However, all required data is not inserting in required sequence new sheet.

Can you please recheck.

Thanks

Hello

You are simply great. It helped me a lot as I had to prepare data for 60K+ rows.

Thank you so much.

Regards

Narendra