I have 4 identical data sheets. which are which auto update from imput sheets
for 4 customers. Can i export the data from thes four sheets to a single
sheet. example
sheet1 cell A1 goes to sheet5 A1 but sheet2 A1 goes too sheet5 A2
and so on.

Is this possible and if so how do i do it Please?