Creating a Master Data sheet (Alpha Information)

[lruffinjr]

So I have been looking around to find a way to have information roll up to a master sheet from multiple worksheets. This includes data that aren't numerical (Names of companies, etc) Ideally, I would like to have Certain information contained in 3 different sheets to be rolled up to one master sheet. For example on sheets 1,2 and 3 I capture information such as: name of company, email, phone number and address. on sheet 4 (master Sheet) I would like the name and number of that person to roll up in the next available line on the master sheet. It was suggested to me to you the consolidated option I tried that but It seems to only work on numbers (equations) and not on alpha data (names)