What should be used in the following situtation Pivots or Macro

[JainAbraham]

Hi All,

I am asked to make a macro for the following:

i have two sheets where in one sheet say Home.xls has few columns in it like

ID	Name	Project	Role	H-RM
jdjs87	Jain Abraham	XYZ	BA	ABC
kkkj03	ABC	kqr	Manager	UVW

<TBODY>
</TBODY>

and the othe sheet say Away.xlsx has simillar columns with only ID similar to the one in the Home.xlsx

ID	Name	A-RM	Start date ...
jdjs87	Abraham Jain	KJB	12/12/2014
djfkaj	LMN	JKL	09/12/2014

<TBODY>
</TBODY>

ID will be my connection for the two sheets.

i need to create a view that will display somewhat like the following

ID	Name	H-RM	A-RM	Project	Start Date
jdjs87	Jain Abraham	ABC	KJB	XYZ	12/12/2014
kkkj03	ABC	UVW	JKL	kqr	02/20/2014

<TBODY>
</TBODY>

i know this can be done in macros wherein i can have a new sheet with the third table but what i want to know is can i achieve this using Pivots. I know how to work with macros but i have never worked on Pivots and i feel this can be one opportunity to do that. I just want to if we can do this in pivots?

I was not sure if this post will come in the Power Pivots thread if so tell me how to migrate it there and ill do it.

Thank you in advance.