I am not entirely sure what you are trying to do. However let me try to answer as I understand your question.
You first need to be able to change the sheet name in VB. The simplest way to find out how to do this is to start the macro record, change the sheet name, and then stop the macro. When you go into VB you will be able to see exactly what was recorded and it will then be simple to figure out what information you need to generalise the procedure.
Next you want to take the information from a cell and use that information for the sheet name. VB is event driven so you need to find the event that will trigger the change. I would suggest the Worksheet_Change event.
There are some ramifications in doing this though- especially if you are using multiple worksheets. The sheet name often is needed in referrring to a cell and if they can dynamically change, then your VB code will return an error at some point when the sheet names do no match. You need to think as to how to work around this. Not knowing you application I can't help you further.
You can get a good idea of how to work with Excel and electronics from my book
"Excel by Example : A Microsoft Excel Cookbook for Electronics Engineers " ISBN 0750677562, published by Elsevier/Newnes. It covers most of what you are asking here.
Incidentally, the book was based on a series of 3 articles in Circuit Cellar Online
**broken link removed**
**broken link removed**
**broken link removed**
This will give you a general tutorial. The book has a different approach and is much more detailed with many more examples.
-Aubrey Kagan