Using head in VBA

I would like to automating some operation with macro, and here is a problem with the head.
At the beginning I’ve attached files that are done as a model - to represent how the macro works.
1) 5 variable with limit
or second file 2) variable_s_f - a slightly different approach to the macro code (more advanced)
Here I received a comment to second file model (comments are also attached directly to the code)
“Based on your subsequent procedures ...
I'd make a list of sheets with the proper Name.
On the basis of the number of sheets of Num - names identified shift.
I’d pass by to (for) copy between worksheets source only one time.
Immediately copied all the data from the spreadsheet, taking into this shift,
without. Insert Shift: = xl down.
Because if you add another sheet still u need to change the contents of the procedure.
The question is sort of sheet names in a table?”

Comment attached directly macro - translated:
„const bo nie wiem czy nie powinny to byc parametry
const because I do not know if it should be the parameters

'**1 docelwowo wlaczyc ta linijka i bezwzglednie wtedy '**2
** 1 ultimately enable this line and then ruthlessly '** 2
zrodlo - poczatek danych w kolejnym arkuszu
source - the beginning of the data in the next sheet
pobieranie wszystkich danych z danego arkusza
download all data from a spreadsheet

opis po lewej tylko z 1-go ark bo zakladam ze sa takie same?
description on the left but from the 1st to the sheet because I assume they are the same?
nazwa arkusza zrodla
sheet name of source
a moze jednak albo copy values albo value=value?
But maybe, or copy values or value = value?
gdy wylacz
when you turn off”

I’ve tried to process these macros so that the function well with the head, but there is something wrong - file 3) 5 variable head

4) 1995-1996 makro test The target file in which I want to use the macro by the rule laid down in one model
So, that added 1997
As regards the differences in relation to model is:
• 4 TITLE D (1 +2 +3) and 8 NAME H (5 +6 +7) are summarized. I don’t know whether it makes sense to implement into the macro. May be better is to add a empty blank row in the macro, and later I’ll be copied it by "hand".
• The final major difference is the table ”changes” where date doesn’t get from created separate sheet for 1997/1996 as a sheet of data taken in 1997, etc.
Only always takes directly from a single sheet of "changes" horizontally eg. C5 H5 etc.
Thank you in advance for your help.

AttachmentSize
5 variable with limit.xls48.5 KB
variable_s_f.xls56 KB
5 variable head.xls49 KB
1995-1996 makro test.xlsm137.91 KB