Excel 2007 : Copy/paste rows based on approximate search condition?

Hi guys,

I am having trouble programming a macro that will retrieve entire rows of data from a reference workbook that contain a desired value in the H column. The trouble is, I would like the desired value to correspond approximately with a cell value on the first sheet in the following way.

Say for example the original sheet contains "John Smith" in cell A2. I would like the macro to search for and copy/paste into this sheet all rows of data from the reference workbook for which row H is titled "Smith"

If its too much trouble, I can use an exact match there.

I cant say I have any code to show you as every attempt I make at this seems to hit further from the mark. Thank you all so much in advance for your help.

It would, however, be useful to have a sample workbook to look at.

Regards