The master sheet's first row is reserved for 3 command buttons, and the second row is for headers. Column A is an index column filled in A3..A37 with "Res01", "Res02", ... "Res35". Column B is "Name," C is "Food", D is "Drink", and E to I is "Info1" to "Info5". I filled in "Names" with a random name generator, manually made a few entries in Food and Drink, and then filled Info1 to Info5 with calendar months. You can change those names and, as the macros are written, the order in which they appear.
After the Master sheet is a sheet to store the Macros.
Then follow the "Food" and "Drink" sheets that were filled with the BlockValues macro. That macro is currently at Macro:A2. More "Cheat Sheets" can be inserted around here, as long as they have unique names.
Turning to the Resident Cards, I then created a sheet for each Resident called "Res01," "Res02" etc. A macro at Macro:H2 automated that task.
I then entered the headers from the master sheet into cells Res01:A1..A8. I then copied Res01:A1..A8, selected Res01:A1..Res35:A1, and pasted, which pasted the same headers into all the other Resident cards.
I then created a macro at Macro:C2 that allows the user to select a resident number on the master sheet, and the macro takes the user directly to the correct Resident Card, which can be printed manually. A button was placed over column A to run that macro. It uses a subroutine to make sure that the user has selected a Resident in column A, and if not, gives the user a chance to do so. That Verification subroutine is at Macro:H10.
Finally, I created a macro as Macro:C10 that allows the user to select a resident number (as with the navigation macro, and with the same verification subroutine), and the macro then writes or updates the Resident Card with the data currently on the master sheet, as well as the cell color, the cell font color, and the borders and border colors. It leaves other properties on the Resident's card unchanged. A button on the master sheet starts this process. This macro deserves some explanation.
* It loops down the list of header categories in cells A1..A8, until it reaches a blank, returns to the top, and stops (Macro:C12 and C21).
* It locates the address of the cell on the master sheet that relates to the current resident and the current header category (Macro:C13..C16).
* It then copies the "Value", "Text_Color", "Fill/Pattern.Fill_Color", and "Border" properties from that cell to the cell 1 column to the right of the header categories (i.e., B1..B8) on the Resident's card (Macro:C17..C20).
That should get you started. There is an index in my QP book that can lead you to discussions of most of these commands and functions.
I've set up a system that does this, at least if I understand it correctly. Unfortunately, I don't see how to attach anything that is not an image or a video here; otherwise, the QPW file would be attached. Instead, I've uploaded it to the QP page on my web site: