Is it possible to have a button on a worksheet which
would output an excel file or a word file with just that
sheets information on it?

A lot of the cells contain formaulas.

Also how can I get the button to call the file by the
worksheet tab name