Try this out tell me if it suits your needs, the import could be automated but would need more work.

Thanks Shaun seems ideal for what i want, however the problem is it seems to import extra horses for each race, for example caulfield race 1 it imported all the race 1 runners plus another 10 or 11 from somewhere else. Also if you could enable the sheet to be able to reproduce the formulas that i put in it to each new race sheet thta is produced if that is possible that is. Dont enough excel to know if that is possible. Thanks again for your efforts.

Ok fixed that issue, it was not clearing old data should be ok now.

The formula problem is more difficult because it only copies values and to copy formula you have the issue of the name ranges and formula references.

unless you need to update the sheet putting the formulas you need on the main sheet to do all your calcs is the best option then the final result will be copied to a separate sheet.

Thanks alot Shaun, appreciate the time and effort, saves me alot of data input.