Creating dashboard from Multiple Google Sheet

Hi Community,

I have some basic knowledge of Lookerstudio, 

I have a sales report for 4 different regions( E.g A, B, C, D) in a Google Sheet And each region has its own month-wise Google Sheets. One google Sheet is for ONE month 

More detail

A - is having a monthly sales report in Google Sheets e.g 12 Different sheet for 12 months and Each spread Sheet is having sales Day wise

So can you please help how should I create a dashoboard in which when I select a month or date it should give figures accordingly of all region at once. I dont have to invdivdiually go to each sheet and see the report.

 

0 5 193