How to select ranges. Also works on Rows and Columns (with some differences):

http://support.microsoft.com/kb/291308

And Selection has a boolean Hidden property. Set it = True to hide.

But I too would keep the original data in one sheet (in the same file) and either generate a new sheet from the inputs or create a second sheet that displays the subset of data via lookup formulas. It depends on the nature of the data and the intended use for the resulting sheet.