|Assuming you were able to paste your data into a WorkSheet, what do you want it to look like once that's done?|
In other words, since the data is "up to 10,000" columns wide and up to 200 rows, what are you expecting to see once the data is in the worksheet? We know it can't be 10,0000 columns by 200 rows, so what are you willing to accept?
The code below will allow you to access the clipboard from VBA and store the copied data in a variable. Once there, you can use various text functions to manipulate the data.
I opened a text file manually, selected all of the text, copied it and then ran the following code.
As written, the code will put each individual character, including the tabs, into its own individual cell, A1 through IV1 then A2 through IV2, etc.
'Get data from clipboard
Dim DataObj As New MSForms.DataObject
Dim cbText As String
'Store text in cbText variable
cbText = DataObj.GetText
'Put each character into a cell
For numChr = 1 To Len(cbText)
nxtCell = nxtCell + 1
Cells(nxtCell) = Mid(cbText, numChr, 1)
P.S. In order to use the DataObject in your code you must set a reference to Microsoft Forms 2.0 Object Library in the VBA editor.
Tools...References...Check Microsoft Forms 2.0 Object Library