I use the following formulas to bring in data from other worksheets in a
workbook. Currently each formula brings the data into a separate cell on
sheet 4. I would like to combine all three formulas to bring the data into
one cell instead of three indivudal cells. How can this be done?

=SUMIF(Sheet 1!D:D,"Your Name",Sheet 1!E:E)
=SUMIF(Sheet 2!D:D,"Your Name",Sheet 2!E:E)
=SUMIF(Sheet 3!D:D,"Your Name",Sheet 3!E:E)

Thank You