Help Referencing other Workbook cells

Here is what I'm trying to accomplish I appreciate any help. I haven't done VB in ages and never within Excel

Reference closed workbook in same folder
Search column A for specific value
Once I have the specific value copy and paste a certain column value from the matching row into another workbook

I can accomplish this by copy paste but rows are added often. So I figure this is a more dynamic fool proof way of not having to redo a worksheet once a month.

Again any help is appreciated. I have to do this many times over so a framework to reference would be awesome.