Insert line over Multiple sheet

[sajohnson05]

This is my first post as I am just now learning how to use macros. What I am looking to do is find a date ie 8/1/13 on different sheets in my workbook and these are on different lines. Once I find that date I would like to insert a line below, add the current date in column A and copy the formula above from column b - k. Any help would be appreciated.

Thanks

 

[sajohnson05]

bump. Any help would be great