Macro Help

I'm new to macros and I've just started trying to learn some basics but I'm not sure how to do what I need.

I need a macro to do the following

Insert Design table (for a part or assembly)

*Design table is custom and is stored on local network so I need macro to point to this location to import.

After design table is inserted, is there a way to populate the design table fields applicable to the individual part/assembly with data from an excel spreadsheet also stored on local network? For example, after custom design table is inserted, macro will look up the part/assembly number from an excel spreadsheet, find the fields for that particular part and insert them into the correlating fields of the design table. 

I've attached a snippet of the custom design table and the excel spreadsheet for the data to be inserted. 

I would greatly appreciate any help anyone can lend.