Creating a Automatic Alpha transfer from other sheets?

[Teresamlo]

How do I create a cover sheet that only automatically transfers the alph and
numeric items from another sheet, for example, I have five lines of alpha
and only one of them has a numeric it's this one I want to automatically
transfer, is this possible in Excel?

 

[Teethless mama]

Yes, it's possible, give us some examples