Loop filename and variable name

I want to make a loop that loops over the number 2011 in the following script.

[~, ~, raw] = xlsread('Q:\Karl\HH\FUT2013\LOTTE\2011.xlsx','B8:I18');
H2011 = reshape([raw{:}],size(raw));

[~, ~, raw] = xlsread('Q:\Karl\HH\FUT2013\LOTTE\2011.xlsx','B28:I38');
G2011 = reshape([raw{:}],size(raw));

As you can see, "2011" is the filename, but also used in the matrix definitions (H2011, G2011). Also, I call on a specific cell range from the excelfiles (B8:I18, b28:I38).

I have several excelfiles with names "2011", "2012", "2013_1", "2014_1", "2014_1s2" and "2014_1s5". Instead of repeating the excact same commands as aboove by changing "2011" in the filaname and matrix name for all the names mentioned, I wish to make a loop that does this. Does anybody have suggestions?

I have asked the same question before, http://www.mathworks.se/matlabcentral/answers/74778-loop-file-and-variablenames-when-importing, but the answer didn't work.

Answer 1

[Image Analyst]

See the FAQ for code examples: http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

[Karl]

I think I get the loading part. The problem is looping over the variable definitions...How do change "H2011" and "G2011" in my example with H(i) and G(i) where i = 2011, 2012, 2013_1, 2014_1, 2014_1s2 and 2014_1s5?