Google sheet Copy with importranges

Job ID: 33564748

Budget: ₹600 – ₹1,500 INR

I need to make some automations in Google sheets ,i have the lay out and logics only needs to put formulas according to the logics