Excel beginner - Specific cell referencing between worksheets

Hi, I have very minimal experience using excel, however it's an important skill for me to develop due to my new job.

I'm wondering if it is possible to select cells from an ongoing table on a worksheet then copy it over to fill out a form on another worksheet using a macro that can be assigned to a button.

I have already learned how to record simple macros and assign them to buttons however the trouble lies in being able to record a macro or form a formula that will allow me to copy data from a table that is ongoing and being updated and paste that date into specific cells onto the next worksheet. Any help would be appreciated, thanks.

Fast answers need clear examples.

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.