Creating table using equation based on three variables.

I have a worksheet that has three user input variables, let's call them Z, Y, and X, that iterates to arrive at the desired answer, A, using a macro. What I want to do is create a table with X and Y as my main axis and Z as a sub axis (paired with the Y axis). The data in the table would be this iterated A value that is calculated when those particular X, Y, & Z values are placed in the worksheet. The result would look something like shown below.

Ai = (53Xi+Yi^2)/Zi

________X1____X2___X3____X4 ...
Z1_Y1___A1____A2___A3____A4
Z1_Y2___A5____A6___A7____A8
Z1_Y3___A9___A10__A11___A12
Z1_Y4__A13___A14__A15___A16
Z2_Y1__A17___A18__A19___A20
Z2_Y2__A21___A22__A23___A24
Z2_Y3__A25___A26__A27___A28
...

Obviously the formula isn't as simple as shown above or else I would just place it into each cell where I need the corresponding A value. I can't quite seem to figure out how to get a visual basic macro to work for this as I am relatively new to basic. In the worksheet that calculates the A value, all the variables are in different cells.