I have 5 sheets in a template workbook. Cell D4 in 4 sheets could contain the same data depending on which sheet is needed when opening the template, the 5th sheet is where the data needs to be linked or collected. In sheet 5, B7, I want to have the data collected from all 4 sheets, but only one sheet will have data entered in D4, others will be blank. How can I have B7 in sheet 5 collect the data from one of the 4 other sheets, must start with; =location of D4 in the first of 4 sheets, how does the data get collected if in another sheet, there must be a separator used between links?
Thank you.
Thank you.