Try this guy out....not pretty, but might work for you.

CREATE PROCEDURE GetRows

        @Column varchar(25)

AS

       DECLARE @Sql Varchar(50)

       SET @Sql = 'SELECT ' + @Column + ' FROM Table1'

        EXEC (@Sql)

GO