Insert multiple sheets after convert raw sheets into main

I have a file with downloaded only one sheet from system and want to automatic insert the multiple sheets with some relevant informations.

Please refer my attach file.

In this file,I have downloaded 'MB52' sheet.Now,I want the following datas with the help of VBA codes:-

1-Automatic Insert a sheet ,name-'PhyInv from MB52 sheet'.In this,text in row no.4 should be BOLD.Further,automatic calculation on columns 'AB' to 'AD'.
2-Now,please refer the Column 'F'.In this ,Sloc is appearing e.g.AL01,DC01 etc.
3-'Sloc' wise insert the sheet with sheet name of 'Sloc' e.g.AL01,HT01 etc. ( Shown in Tab Colour 'Green')
4-Take a example of one sheet,say,AL01.
a-Automatic Insert Cell no.B4 and C4 from F5 and G5 of the sheet 'PhyInv'.
b-Cell No.B5,C5,D5,E5 and F5 from C4,D4,AB4,AC4 and AD4 of the respective 'Sloc' i.e.AL01.
5-Insert a column in each sheet i.e.'Phy-Qty' should insert with pixels of 90 and appear in column 'G' only.

Is it possible through VBA Codes?

Hi Pradeep

Try the Code in the attached. CTRL + x is the Keyboard Shortcut.

There are 2 problems appearing:-

1-SLoc total is not matching.I have check only one i.e.RD01.In sheet 'PhyInv'total qty of RD01 are 203 while through VBA codes it is appearing only 198.
2-'Material description' is appearing as 'Material' in all the sheets.

For more clarification,please refer my attach file.I have highlighted the BOLD letters on 'PhyInv' sheet and next to 'RD01'Sheet.

Hi Pradeep

I believe these two issues are handled in the attached...let me know of issues..

1-SLoc total is not matching.I have check only one i.e.RD01.In sheet 'PhyInv'total qty of RD01 are 203 while through VBA codes it is appearing only 198.
2-'Material description' is appearing as 'Material' in all the sheets.

Now,it is working fine as desired the result.Glad..........to find it.Thanks for your nice cooperation.

You're welcome...glad I could help. Thanks for the Rep.