Macro recording, selecting rolls based on found data

I have many many route sheets to edit. The problem is that the sheets are not standard even though they contain the same information. I want to insert a row below a certain value but that value is present on different rows on different worksheets. It may be on row 26 on one and 28 on the next. I have tried to record a macro that finds that value and then on the next row inserts a line but it assigns that row # to the macro. Example: finds value on row 25, the next line reads something similar to...

Rows("26:26").Select
Selection.Insert Shift:=xlDown

Any thoughts? I hope I've made things clear. If not I'll amend additional info.

Thanks,
Daniel