Assign function result to a table variable

Declare @Data as table (FieldValue varchar(100))
insert into @Data select * from MyFunction ('Person.Address','AddressID')

-- Function
Alter function MyFunction (
   @TableName varchar(100), @FieldName varchar(100)
) returns @GetData table (
   FieldValue  varchar(100)
) as
begin
        Declare @SQL varchar(250)
        Set @SQL = 'Select '+@FieldName+ ' from '+ @TableName
        Exec sp_executesql @SQL
        return
end

INSERT @TableVariable
EXEC spYourProcedure

INSERT @TableVariable (FieldInSp1, FieldInSp2)
EXEC spYourProcedure