Join multiple excel worksheet with specific table range - Batch Macro

[abhishekyx]

I have an excel template with table range (C7 to K37) in multiple worksheet. Would like to combine the all the worksheet. The schema could be different (based on input value) so I believe a batch macro would be required. 
The current problem that I am facing is - the template is reading from Row1 to Row37. Ideally it should read from C7 to K37 as I selected the same in batch macro template. How can I configure this so it just read value from the C7 to K37 and ignore everything. 
Also, how can I avoid the Null value if all the given row and column are not filled/ of few row are filled in template of any of the sheet.
Attached excel template. 

[Raj]

@abhishekyx 
while feeding the sheet names you will need to add the range as well
C:\...\Template.xlsx|||`Sheet1$c7:k37`
yes you will require the batch macro to achieve this
find a macro for reference
hope this helps.