Creating a SEC 13D filing table with web query

ShosMeister, my apologies for the delay; I didn't have my work computer available to post the Excel file last night.

Attached is the excel file I'm working out of. When you run the macro, you'll see data pulled from the WhaleWisdom website on the sheet called "original data." The sheet called "My Sheet1" has the names of the columns I want (as described in my above post) with comments explaining what from the original data columns goes to the "My Sheet1" columns. "My Sheet 2" also has the columns I want, described above too, with comments explaining how it relates to the original data sheet.

As you pointed out, I would not want the previous data to be overidden each time I run the macro, but I don't need the raw data as it appears in WhaleWisdom's columns.

Thank you so much for offering to help with this; I really appreciate it.