Macro to create multiple sheets from template and fill with datas from one sheet

Hello all,

I have a file which is used to tabulate the results of a competition.
I have a sheet(list) which has the datas like competition number(b4:b33), Driver(c4:c33), Co- Driver(d4:d33)
and Category (e4:e33).
In another sheet named (Template) which has the format of the sheet to be copied.

In the list sheet if the comp no=1 driver = david co-driver = john and category = Expert
then it should create a worksheet with name "1" competition number.

The data must be copied to the respective cells.

File attached for reference.

Somebody please post your ideas.

Hello Admin,

Exactly you are right.
That is what I needed.

That will be fine Admin.
The data from the list sheet should be copied to new worksheet created.
It should occupy the place as follows:
- b4(comp no) = f9 in created sheet
- c4(driver) = f10
- d4(co - driver) = f11
- e4(category) = f12

The sheet name should be the value of b4.

Hope that helps.