VBA Pulling Data From Other Sheets Remove Duplicates

Hey All,

I have three worksheets in this sample workbook, but my real workbooks could have many more worksheets. My goal is to create a macro that will pull all of the row data from the "160" and "300" worksheets onto the "Main" worksheet, but I don't want to have duplicates on the "Main". The "160" and "300" worksheets will have some identical rows.

I would like to have the data in the "main" sheet sorted by Column A and then by Column C and D. Also, I would like to leave a couple blank rows after there is a switch to the new symbols in column A.

Column F will have clickable hyperlinks that can vary in length depending on the length of the article title. If the title goes past the page break, I would like to create a new row to continue F column data directly below the corresponding row.

It is important to add that there could be hundreds of rows depending on the day, so the macro would need to look down the columns and not be limited to the sample worksheet data provided.

Any help would be much appreciated. I have attached the spreadsheet.