I'm looking for a way to copy and transposing paste between Sheets : in sheet “Planning” I have the small jobs assigned to some people with a summary line that tells me if they are free (they can do up to 3 jobs M and P)
In sheet "Peter", "John" etc. I have shared planner of that people, where each one marks in his sheet other personal commitments divided between morning and afternoon for each day. There are also two spaces “M and P” where everyone manually marks the existence of commitments with me.
I would like to copy the values in “Peter” row from sheet Planning and paste in the M and P columns in the Peter Tab and so for everyone to avoid manual entry. (I have 35 people tab with six months planning)
Meanwhile I find formulas that I placed in Peter tab – columns M and P – according to the date
Formulas for Peter Tab, now only for October and November (changing row numbers)

Cell B4: =transpose(query({Sheet1!A3:DT3},"Select "&ArrayFormula(join(", ",text(query(transpose({column(Sheet1!C3:BL3);mod(column(Sheet1!C3:BL3)-column(Sheet1!C3),2)}),"Select Col1 where Col2=0"),"Col0")))))
Cell B5: =transpose(query({Sheet1!A3:DT3},"Select "&ArrayFormula(join(", ",text(query(transpose({column(Sheet1!D3:BL3);mod(column(Sheet1!D3:BL3)-column(Sheet1!D3),2)}),"Select Col1 where Col2=0"),"Col0")))))
Cell B44: =transpose(query({Sheet1!A3:DT3},"Select "&ArrayFormula(join(", ",text(query(transpose({column(Sheet1!BM3:DT3);mod(column(Sheet1!BM3:DT3)-column(Sheet1!BM3),2)}),"Select Col1 where Col2=0"),"Col0")))))
Cell B45: =transpose(query({Sheet1!A3:DT3},"Select "&ArrayFormula(join(", ",text(query(transpose({column(Sheet1!BN3:DT3);mod(column(Sheet1!BN3:DT3)-column(Sheet1!BN3),2)}),"Select Col1 where Col2=0"),"Col0")))))
But it’s so long because as soon as the number of days in the month changes and also I have to delete data from sheet Planning at the end of every week and so formulas break
My question: is it possible to find an automatic solution, keeping the values already entered?