Create a auto-fill excel page from a row of information

[jtramell]

I am not sure if this is possible but here it goes anyway. I want to add a "Button" to a excel spreadsheet, so that when you click on it, it will auto fill another excel sheet with pre determined information from the corresponding row to be printed. Example we keep a yearly (with monthly tabs) master log with all of the information but then we open other workbooks to re-input some of the information to be printed. We have three other documents that we need printed but we don't need to keep a excel file for.

Please help
John