Need help with Excel sheet to generate receipts

Hello Together,

I am very new to excel and I want build something as described below. Please read through it and let me know if it is possible to do so? And if yes how can i do it?

I have an Excel sheet with 5 sheets.

Sheet 1 - Table with Serial Number, Name of students, Staff Teacher name, Month and Associated fees for the month.
Sheet 2 - Table with Serial Number, Name, Description of the Item purchased books and Price
Sheet 3 - Table with Serial number, Name and Donation Amount
Sheet 4 - Table with Serial Number, Name, MISC and Price
Sheet 5 - Receipt Template.

School_1.xlsx

Here is my requirement
In Each sheet from 1 to 4 I want to add button called Generate receipt - Once the button is clicked the following sequence has to happen..

1. Dialogue prompt asking for the student serial number or Row Number
2. With the Serial number, student name from sheet 1 must populate in the Row 10 & Column 10
3. Dialogue prompt for asking which month?
4. Corresponding month fees copied to Row 11 & Column 11
5. If the Generate receipt button is clicked on sheet 1 Row 14 & Column 14 chooses item 1 from the drop down list
6. Automated receipt number generated on the receipt Template
7, Receipt number is copied to Sheet 1 specific column & month
8. PDF copy of receipt is generated and email/whats app to the student

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.