Insert multiple sheets after convert raw sheets into main

[PRADEEPB270]

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?

[HansV]

Pradeep, that is a very big request. The goal of these forums is to help people if they get stuck, not to create a complete application for them for free.
I wrote a macro for you this time, but you can't count on such a big request being fulfilled next time!

PhyInv.xlsm

[PRADEEPB270]

Thanks for the painful efforts.You have done an excellent help.Glad.