Formula to seperate specific data from a data list in sheet1 into sheet2/sheet3

Hi

I have attached a sheet that has part of a data list, sheet called (Full Data) what i am trying to do is seperate the data into event locations into individual sheets.
The data ref will be column F which is the diffrent event locations.

I thought the best way to try and do this was to create an if/ match formula using the sheet tab names as the if match, with the event locations in column F.

I have added two sheet tabs so you can see that i require the data for (Ain) to be put into the Ain sheet.

The data list in Full Data sheet will be continuously updated so i will need the range to be around 10,000 entries

Hope you can understand what i mean

Hi

Thanks for your response, I have just tried that formula and it manages to copy over the first row in the data sheet as i needed but when i copy the formula down on sheet Ain it is Blank, there are at least 55 entries with Ain ref in the data sheet which i need copied over. I think the formula needs tweeking ?

You are correct i am noob the End

Thanks alot +++