Google Sheets- Formula creation, macro writing.

Task 1, Formula creation. Cell C8-C11 can manually input data of values of R1, R2 up to R12 in any combination, cells also can be empty. example C8-C10 can have values and C11 does not. Cell E14 will display the answer we are looking for. Condition of formula, We are looking for the missing number in between. If R1 and R3 are present R2 is missing and will be displayed in E14 If R12 and R2 is present R1 is missing and will be displayed in E14 If R1, R3, R5, R7 is in Cells C8-C11, The Missing numbers will be R2,R4,R6 to be displayed in Cell E14. Note: Numbers connected in a sequence, R1,R2,R3,R4,R5,R6,R7,R8,R9,R10,R11,R12,R1,R2 and so on. An ideal solution will be a one-line formula that if a reference table with fixed values is required, another sheet can be used and referenced to. If the formula requires a table with variable values, Cells V1-AA5 can be used. Task2, Macro writing. Teach me to and assist me to create a macro that when run. when mouse is selected A value is a name creates a new spreadsheet with that name, then goes back to the same sheet then copys the B value and pastes it in a specific cell then goes back to the original sheet and copys C value and then pastes it into the new sheet within a specific cell and so on.