Fix data in sheets from Master sheet

Hi Experts !
I have one Master data sheet containing all data reside there. I want to fixed the data( certain columns data) into different columns of sheets ( Method1,Method2,Method3,Method4 so on) based on the name of the sheets.
the template is attached .

Hello Farrukh,

Even though that Mumps has solved this for you, here's another option seeing that I've done the work on it. Its just a slightly different method to Mump's but for the same result. I did the same as Mumps with the merged cells and I also deleted the empty row4 just to tidy up the MasterData sheet a little.

Please Login or Register  to view this content.

You'll need to ensure that all sheets are created first. Click on the "RUN" button to see it work.

I hope that this helps.

Cheerio,
vcoolio.

Hello Gurus Mumps1 /vcoolio
That is wonderful work and help you both saved at least two days for me to copy one by one in respective sheets 90+
only little changes required
@ Mumps1 can it possible the data appear in sorting I mean first old data then new dates ( because i have many sheets to fix the data )? also required to delete the data from template for next use?
@ vcoolio I need to mentioned all the sheets in the array right ?

I am sorry ! since all history data reside on master sheet from master sheet not required delete . The sheets method1 ,method2 so on required to clear the cell for next use.
appreciate your efforts

bundle of thanks ,God bless you !

Good day Farrukh,

@ vcoolio I need to mentioned all the sheets in the array right ?

That is correct.

Cheerio,
vcoolio.

By the way Farrukh,

I've just noticed that the sample file didn't attach in my post #3 so, for what its worth, here it is:-

Cheerio,
vcoolio.

Hi Mumps ,
I am very sorry to bother you . Your code absolutely working 100% . I tried one more thing but not get out I need your help. if in master sheet contains more names (method7,method8 or up to method300 ),so the VBA code by pass the names of Master data sheet(items) and keep only fix the data of sheets which are available in current case method1 to method6 sheet is available.