I have a sheet which uses query table to download several different tables of stock data onto a temporary sheet "Raw Data" based on input stock code on main "sheet1".

Basically I need a code to create a new sheet with the name of the stock code from "sheet1".

However, I want it to search through all the existing sheets, and if that sheet exists already (i.e has been searched previously) then I want that to become the active sheet. I will then append the data to the end of existing data on that sheet.