I want to use the code below with something added that says {If End of sheet, create new sheet, continue import on new sheet.}

Workbooks.OpenText Filename:="ftp://ftp.unknown.com/CSV_feed.txt", _
Origin:=437, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlNone _
, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:= _
False, Space:=False, Other:=True, OtherChar:="|", FieldInfo:=Array( _
Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 9), _
Array(8, 1), Array(9, 2), Array(10, 9), Array(11, 9), Array(12, 9), Array(13, 9), Array(14, _
1), Array(15, 1), Array(16, 9), Array(17, 1), Array(18, 9), Array(19, 9), Array(20, 9), _
Array(21, 1)), TrailingMinusNumbers:=True