Generate tabs for each material in overview

So I attached a sample book and what I want to achieve is a macro that makes for every material on the fist tab, to make a seprate tab with a certain header layout.

As you see this example has 43 lines which means it has 42 materials (next months it could be more or less).
Now for every (unique; but they should be unique) material I want the macro to generate a tab and name the tab the name of that material.

The heading on this new tab should be like you can see in the first material tab (A1030-020) in the sample data.

As said every month the data will be refreshed and the macro should re-do everything for the materials that are then present in the updated data.
So throw out the old tabs (except the first of course and another tab that is in the org file but not in this sample).

Could somebody put my on my way with this request?

So the purpose is to create an empty sheet for each material with just the header row without nothing else ?

Thanks this works perfect @CheeseSandwich!

And yes @beyond Excel before going to the next material tab I have to build in still some formulas.
But the data for that is in a much bigger tab that I left out here.

Actually the old data for previous months gets re-created every time because for that month we are only interested materials that are on the first sheet.
Next month there could be a material not in that is on current months sheet and there should be no tab made for that one then.

Every month the total book gets saved with idicator of which month/year.

Not sure if it can be done better. User just does want only materials in that are on first sheet.
And if you also need history per material you can do it only to recreate all history every time instead of just adding the new line for a material.

Idea's would be welcome.

Question @CheeseSandwich you had this :

Please Login or Register  to view this content.

I put in this for also filling the Material in column A in the template:

Please Login or Register  to view this content.

How could I also make it fill column D automatically?
In the data material is column A and PF is always in column F and needs to be pasted in template in column D

Tried several thing on the unq variable you made but cannot make something similar that always gives me the correct PF for that material.

Yes this would do it! Thanks CheeseSandwich

With this example I can improve my code.