Excel and more than 1 workbook

[phoenix]

Now in each workbook you can have multiple tabs. Is this what this question is covering? If so, I was unable to select the correct tab using this code.
e.g. Proposal1 - Proposal2 - Proposal3, Each of which have their own tab but are in the same workbook.

Thanks for your time.

Best Regards,
px