Automatically creating a new sheet based on one data sheet

[herbertlikesherbert]

Hey MrExcellians,

I am currently stuck on an issue. I am creating an excel file which will hold stock levels among other information to do with festivals and markets attended. Let's say column A will house the Festival/Event name. The adjacent column might hold the date and the cell adjacent to that might hold the stock level of a product and ultimately every cell in that row will hold a new piece of information. Completely raw data.

Every time I put a festival name into column A, I'd like a new sheet to be generated which will be a template, and then as I enter in the data across the row, it will automatically populate the newly created sheet. The goal is to have a sheet for every event created under a template and organising and using the raw data.

Is this possible? I'm thinking macros, but I'm not too well versed myself.

Thanks,
herbertlikesherbert