Help with If function

I assume this would be done with a nested if function, but am asking for advice.

Have large spreadsheet in which I will select a range of numbers to be moved to specific locations.

These numbers fall into 3 major groups and each major group is further divided into two different subroups.

I wish the user to enter into a cell -- sheet 2 A10 for example -- a value -- then once the values are picked the macro will look at this A10 value and then move the numbers to my specifiec location. I am copying below the code for an example of this -- the values are arranged accordingly in the next empty cell everytime control a is hit. My question is -- how can I specify where this location is to be based on the value put in A10?
Thanks for any suggestions and or help with this --

Please Login or Register  to view this content.