Automatically Convert all columns to a named list column based on the first cell data but incorporating all data in the column as part of the named c

[jetbluebob]

Hello All,

I am trying to put together a spreadsheet that will be, pretty much automated, after importing data from another sheet.

I am currently able to Sort the Data based of the import to other sheets based on the first column data which for this case is City. But the issue I have, is the new data that was sorted out to the different sheets no longer has a Column List Name. Which sorta puts me a stand still... Is there anyway to create a script to autopopulate the current header in the List Name Header for the Column?

City	CrewID	Full Name	Email	<-- This row 1 - needs to become a Named List Column using VBA so i can use it on the 90 other sheets and it needs to automatically be named based on the Row 1 Value and the length needs to be Dynamic
CITY1	2341234	John Smith	John@John.com
CITY1	12344123	John John	john@123.com
CITY1	12341234	John Smith	John@John.com
CITY1	54353	John John	john@123.com
CITY1	5623456	John Smith	John@John.com
CITY1	23452	John John	john@123.com
CITY1	23452	John Smith	John@John.com
CITY1	2345	John John	john@123.com
CITY1	3452354	John Smith	John@John.com
CITY1	2345235	John John	john@123.com
CITY1	234524	John Smith	John@John.com
CITY1	2345	John John	john@123.com
CITY1	8866	John Smith	John@John.com
CITY1	565	John John	john@123.com

<tbody>
</tbody>

Any help would be greatly appreciated