I am trying to create a list of all treatments received by my patients. On my master Overview page, I input the new treatment date, it is then automatically forwarded (pulled actually) using ="Patient 1"!M4 on the individual patient sheets into a cell (D4). Column A is a dynamically expanding list down the column that captures these treatments, but i cannot figure out how to connect D4 to the empty row below the list in Column A as it grows (actually causing it to grow). Any help would be grateful. I am not a computer wizard by any means.