Printsummary Sheet pulling information from other sheets based on value in one cell

Dear all,

I am stuck with a Project and I was hoping to find someone who can help me with this. I have posted the Details here already. I can do it with nested IF functions, but that would be a huge amount of formulas. Any help would be greatly appreciated.

Hi Carim

I posted a link to here in the other Forum because I don't want to be in breach of the Forum rules. My original message was:

I am stuck with a Project and I would Need some advise. I have created a schedule that can be used to track attendance in the Computer. But it is too large to print (on letter size/A4 paper). So I would like to create a Print Summary sheet, which pulls the Information from a specific sheet.

Example: I enter my schedules in sheet KW1 for my staff. This sheet is set to print ok on A3 Format. But as there are not enough A3 Printers, I Need it in A4 Format. For this, I have created the sheet 'Print'. On this sheet, I want to be able to enter the sheet Name (KW1-52) in cell B1, from which then, the 'Print' page pulls all the data from. It would eg. pull in row 7, the ID No, Name, Carryover items (RU, UR, GT, GS) and then the daily start and end times, exactly as they are on sheet KW1. And if I enter KW2 in B1, it would pull this Information from sheet KW2, etc. There should be no further calculations on the 'Print' sheet, it is purely to Format the data for A4 size printing.

I don't think an IF function would work as there will be 52 Sheets to pull from…. is there any other Option to achieve this??

Any help would be greatly appreciated. The file is attached.

Thanks so much for your time!

Hi Carim

you are a star!! I knew that there was an easier solution than IF Statements. I tested it quickly, it seems to work like a charm!!! Thank you so much!!!!!!!