Open multiple text files to different sheets and save each sheet seperately

Hi Excel gurus,
I've been pulling my hair out trying to do a potentially easy code for some experienced people, if anyone can help!

I'm looking to :

1) Open multiple file names from my F drive.
Details - With the file name of "issue303661.txt" the following file would typically be consectuive e.g "issue 303662.txt" but not necessarily.
Is there a way to have a simple macro that opens all text files in F drive no matter the name and inserts each text file into different worksheets that are space delaminated.

2) Renames each sheet to a specific cell
Details - in this case ("G4") of each sheet.

3) I have some code to manipulate the data

4) Save each sheet as a separate file
Details - Export each sheet back to the F: drive. Each sheet would be saved as the name from cell ("G4").txt or .csv.

Thanks for your time in advance people.

Lance