Macro to index a cell and loop a print function on conditions certain cells contain a

Hi all,

I have a workbook in excel 2007 format; with 4 printable worksheets (sheet1, sheet2, sheet3, sheet4) that dynamically autopopulate via an index number reference in E5 on sheet1 run as long as there is data in sheet1 cell
A11(populates sheet2 until empty),
A13(populates sheet 3 unless empty) and A15(populates sheet4 unless empty)

I had limited success with a recorded macro, but as these values are different daily I need a loop to validate the data on sheet1 and then print 1 copy of sheets 1&2 while records exist then sheet2 if A13 is not empty, and sheet 4 if A15 is not empty

I am admittedly not great with VBA and creating macros, I could definitely use some help