Need way or vba code to extract data from different excels to one single template.

[vba_beg]

Hi am new to vba and need help on this which is very complicated for me. Is there any way like vba code where i have different fields in a template and the data can be extracted from other different excels like multiple excels or sheets by mapping the fields.

please help. Hoping

 

[oldbrewer]

template

shop 1 sheet

shop 2 sheet

sales

30000

manager

fred

manager

harry

profit

22000

staff

7

staff

19

sales

5000

sales

25000

costs

2000

costs

6000

profit

3000

profit

19000

clearly the 30000 in the template is =i6+o6

assuming the 2 shops results are on sheets 2 and 3 and the sheet names are shop1 and shop2 this would be

=shop1!i6+shop2!i6

assuming the columns and rows are the same in each sheet

<colgroup><col span="17"></colgroup><tbody>
</tbody>