Find and Open Workbook then copy and move sheet

[cwilson]

Hi all,

I hope this all makes some sense.

I have a template that compiles financial information from various other
workbooks. I want the user to be able open a workbook and then either enter
a worksheet name or select a worksheet and have the worksheet copied into the
template.

I figured out how to get a file open with Application.FindFile, but as for
selecting a specific sheet and getting from the newly opened workbook to the
template, I am lost.

Any help is greatly appreciated.

cwilson