Extract Substring, then Ignore that Substring, while collecting data from Other substrings

Ok this is a pretty complicated question. I am given a txt file "Data.txt". It has a lot of these lines

[GPS: Central time,lat,dir,lon,dir,vel,cog,trk]
135921.00,3609.75843,N,09008.86165,W,N,,29
[GPS: Central time,lat,dir,lon,dir,vel,cog,trk]
235921.00,3809.79843,S,09008.86165,W,N,.01,29

What I'm wondering is how to extract each of the "Central Time" "lat" "dir" etc. from the file's first line. Then ignoring them for the rest of the file while still extracting each of the "135921.00" "3609.75843" "N" etc . I keep getting confused as to which variables I'm using or if I'm even using them correctly. Any help would be appreciated.

Note - I already have the file opening, just need to know how to access the string/substrings. I'm also having to post the "Central Time" ect. as titles from A1-H1, as well as continuously post the data from An-Hn. In case anyone knows how to do that dynamically either.

I just tried to use the function, but I couldn't quite figure out how to do it with the variable of the different files that will be added. See most of it needs to be variables that just read in the title (which could change from file to file). The delimiter being "," was a good help though. Just can't figure out what looping style I need to use nor how to use it to extract the substring. Thank you though!

Worked great Leith Ross thank you so much! RSCSmith your's worked too until I found out one of the requirements was that the sheet be cleared each run through, but thanks!