Hello There ExcelForum,

I am in need of help. 2 things:

1) I have numerous tabs of forms inside 1 workbook. I am in need of a "Main Tab" that will be the navigation tab for this worksheet. On it I need a button/search box to:
a)search all tabs for said "search term" for example a unique name(only on one tab not duplicated);
b)display that tab. Thats it!

2) I am in need of a Macro to:
a) Copy a template form from same workbook (for this example tab is named "Master Performance");
b) Prompt a name for a new tab + input that tab name as field A1 (for example... "Davis, Tasha" as tab name and A1 of that said tab);
c) Alphabatize all tabs between the "main tab"{being tab 1} and "master Performance Tab"{being the last}.

I know I am asking for a lot but im stuck and dont know where to turn... we are using it to keep track of performances of employees between management.

Thanks in advance!!!
Nick