Help with Google Sheet formula and automating a tiny project

Job ID: 31141952

Budget: $30 – $250 USD

Problem Description: I have three problems that I am trying to resolve.

1. I'm trying to use Importrange along with the current concatenating formula that I use.
2. Trying to have the B,C,D fields that I today concatenate in 3 different sheets change it to 1 sheet without having to touch it.
3. Automate my Google sheet to export the data to csv file on my local desktop everyday.
Related categories: Google Sheets Google APIs