okay so long story short is i need to transfer data from one excel sheet into another

here is the scenario that i have if somebody could tell me if its possible/feasible or if there is another way to do so...

there are a number of columns with data organized by headers [Weight, Mass, Height, Color, etc.]

the user SELECTS a certain number of rows [say rows 2, 4, and 7]

the user is then prompted for which pieces of data should be copied for ALL of these rows... whether this be through a checklist or drop down menu or anything organized

for example, i would choose the Weight and Mass of rows 2, 4, and 7
to be transferred into a new sheet with only the data for rows 2, 4, and 7 and their Weight and Mass

is this possible? any help, suggestions, pointers, or solutions would be greatly appreciated. thank you in advance!