I think my problem is quite simple and I might have just overlooked the solution but here it goes. I will try to explain the situation to the best of my ability.
I have 300 Excel Workbooks with 3 worksheets in them, each containing different types of data. Of the 3 sheets only Sheet 1 matters and it contains X, Y data in the first 2 columns followed by 2 attributes (name, and description). All of the workbooks follow the same format.
Now I'm trying to add in these X,Y coordinates into ArcMap and then convert them into a single shapefile.
I'm looking for a way to automate this or do it quicker.
I could always add in X,Y data but as you can imagine it would take forever with so many Workbooks