Developing a "Search" or "Find" Macro/ VBA Program

Over the past twelve months, Ive had to quickly develop knowledge in Excel for my job, which is in the social care sector. Before this, I used Excel at school some ten years ago. However, trying to develop Macro's and use VBA is pushing my ability at the moment...

I'm trying write a Macro where I can input a name (first, last or combination), and it will search current worksheet, other worksheets in the file and specified other worksheets/ files. It will then either show me or tell me where the name(s) has been found. This way I can search back over X years of data sheets to see if a certain individual has appeared in previous years files...

At work, I'm using Excel 2010.

Any ideas, suggestions or posts already on this idea would be GREATLY welcome...

Thanks!