Find, Copy, and Paste

Hi, I am new to VBA and am trying to put together some code that will do the following:

Assuming I have the workbook "Results.xls" open (files are attached to thread):

(1) Search Column A on the worksheet "sampleData" in the closed workbook (testData.xls) for the string value "STS".

(2) When it finds the match, select Column C and copy the respective cell value

(3) Paste that copied data in Column D on the active worksheet "Summary" (within the workbook "Results.xls") in the respective row (from Column A) where it says "STS".

I have attached all the sample files I'd like to use to help illustrate my task

I understand this is pretty similar to a V-Lookup, but I would like to learn the VBA procedure to do this.

Thank you for any support provided.