Duplicate Data in separate spreadsheets

I have two spreadsheets with a ton of similar data in column C2 – C350. Is there a Formula I can use to Sort through the Spreadsheet 1 and Spreadsheet 2 data and only pull the data that is not found in either into a 3rd spread sheet?
(and if so Could it pull over the data that is in D2, E2, F2 etc.) This is only really an extra as the 1st formula is most important

Yes. It's easier if you put them in the same workbook.
In cell D2 write:
=INDEX(Sheet2!$C$2:$C$350,MATCH(C2,Sheet2!$C$2:$C$350,0))

Then copy the formula down to D250

This will only work if your sheet name for the similar data is "sheet2" and it is in the same workbook.

What the formula does is pull over the data from Sheet2 if it is exactly the same as in Sheet1. If it doesn't find it, you will get "#N/A"