Locate matching cells in multiple worksheets & report on value associated with match

I have a spreadsheet that supplies server names and associated applications, but doesn't supply storage related data. That data is in another spreadsheet in multiple worksheets. For simplicity sake I created one spreadsheet with multiple worksheets. The Server & Application List worksheet contains server name I want to match in the other two worksheets. It's also where I'd like the storage data to be retrieved and stored.

I want to match servers in Server & Application list worksheet (column E) with server names in column A in the Physical Server list and Virtual Server list worksheets. Once matched I want to pull the STG data from column d and insert it into the appropriate line in column F in the Server & Application list worksheet.

I'm looking for the formula to read both the Physical Server and Virtual Server list worksheets.

Appreciate and help you can provide.