Filter Data - Check If Multiple Sheets Exist

Using VBA, I am running code that filters the data in my column "Account" on my main sheet, creates a new sheet for each account in that column then copies the filtered data to the new sheet. There will always be the same list of Accounts with the exception that there might not be data for one or more.

In that case, I still need it to create a new sheet with the account name but just have some text stating "no data available for his account".

I can find code to search if a specific sheet name exists but, in my case, I don't know which one won't have data at run time.

I was hoping I could put a static list of the expected sheet names into an array and loop through that list and create the sheet for any that it can't find.

My list: FTL, DTB, CAR, BLD, RSG, STS