Macro Dummy

I have written a Macro and it doesn't run the way it is designed and I am having problems finding my error.   How would I solicit help here?   I've written Excel macros for years but this one has me stumped.   Probably easy for the geeks here..

 I have a workbook with several tabs and then a report tab at the end.  I want to identify the search criteria at in one cell and then go search in another tab in a certain row.  When it finds the match it should then go down the associated column a specific number of cells and copy the contents of that cell.  Then it should go back to the reports tab and paste it in a specified location.    

here is my macro...