If the file type is compatible, you should be able to reference information from your source into Excel using an external hyperlink.
You can also record a macro in Excel. Start recording, go through the steps that you want it to repeat, and then stop recording.
Rod Smith, P.E., The artist formerly known as HotRod10