Macro tied to button to copy cells to another sheet even if I re-sort

Hi, I need some help. I am trying to create some way (probably a button with a macro) to basically fill in certain fields of a sheet with the click of a button.

In my file you will see that the first sheet has names and other info on students. The second sheet has a form I created that has certain fields. What I want to be able to do is to click a button beside a students name if they get in trouble so that it will automatically fill in their name (column B and C), ID# (column E), and grade (column F) from the Names sheet into the proper cells on the Form sheet (name goes into D4, ID# goes into cell F4, and grade goes into cell D5). That will just be a time saver and then I can print the form and fill out any additional info later.

I also often sort and re-sort names on this list and the names on the list grows and shrinks as students move in and out of the class. I need the button to still work - copying all the correct info with each name each time.

Can anyone help with this? My mind if fried and I am not really a programmer or anything. I appreciate any help offered. I am using Excel 2011 for Mac but also have Excel 2010 for PC if needed.

myfile.xlsx

hi coolistic, welcome to Excelforum, option, please check attachment, activate sheet "Names", select one non-empty cell in A column and press ATL+RIGHT arrow, check result on Form sheet. You can try it on Mac as well though I do not know if it would work as I do not use Excel for Mac. It should run ok on Excel for PC.