Running for loop that will output a figure obtained from sheet title as follows:

filename = 'SIXJOINED_XY180.xlsx';
sheetnames = {'6.25','5.75','5.25','4.75','4.25','3.75','3.25','2.75','2.25','1.75','1.25','0.75'};
n = length(sheetnames);
p = 1:n;

     x1B1_6_25values = 'B10:B360010';
     y1B1_6_25values = 'C10:C360010';
     X1B1_6_25 = xlsread(filename,p,x1B1_6_25values);
     Y1B1_6_25 = xlsread(filename,sheet,y1B1_6_25values);

     x1B2_6_25values = 'F10:F360010';
     y1B2_6_25values = 'G10:G360010';
     X1B2_6_25 = xlsread(filename,sheet,x1B2_6_25values);
     Y1B2_6_25 = xlsread(filename,sheet,y1B2_6_25values);

     x1B3_6_25values = 'J10:J360010';
     y1B3_6_25values = 'K10:K360010';
     X1B3_6_25 = xlsread(filename,sheet,x1B3_6_25values);
     Y1B3_6_25 = xlsread(filename,sheet,y1B3_6_25values);

     x1B4_6_25values = 'N10:N360010';
     y1B4_6_25values = 'O10:O360010';
     X1B4_6_25 = xlsread(filename,sheet,x1B4_6_25values);
     Y1B4_6_25 = xlsread(filename,sheet,y1B4_6_25values);

     x1B5_6_25values = 'R10:R360010';
     y1B5_6_25values = 'S10:S360010';
     X1B5_6_25 = xlsread(filename,sheet,x1B5_6_25values);
     Y1B5_6_25 = xlsread(filename,sheet,y1B5_6_25values);

     x1B6_6_25values = 'V10:V360010';
     y1B6_6_25values = 'W10:W360010';
     X1B6_6_25 = xlsread(filename,sheet,x1B6_6_25values);
     Y1B6_6_25 = xlsread(filename,sheet,y1B6_6_25values);

hold on;

plot (X1B1_6_25,Y1B1_6_25,'LineWidth',0.01);
plot (X1B2_6_25,Y1B2_6_25,'LineWidth',0.01);
plot (X1B3_6_25,Y1B3_6_25,'LineWidth',0.01);
plot (X1B4_6_25,Y1B4_6_25,'LineWidth',0.01);
plot (X1B5_6_25,Y1B5_6_25,'LineWidth',0.01);
plot (X1B6_6_25,Y1B6_6_25,'LineWidth',0.01);
figure(1);
legend('Buoy 1','Buoy 2','Buoy 3','Buoy 4','Buoy 5','Buoy 6');
xlabel('x (metres)');
ylabel('y (metres)');
title('H_s 6.25');
print(sheetnames, '-dpng', '-r600');