Dynamic Table based off User / Shared Workbook

[Robby19]

Good day!

I am creating a Shared Workbook and need to create a dynamic table based off of the CurUser (defined name). Want to know if this is possible.

Table1 (Dynamic)

ID #	Correspondence Name	Submitted By	Submitted On	Due Date	Last Action Taken (LAT)	LAT By

<TBODY>
</TBODY>

When a user opens the workbook I want the data in Table1 to change based off of their assigned user info. Table1's data comes from the Log table which contains all info for each correspondence for every user in the exact same format.

Example (The following data should be pulled from table Log);

CurUser = Billy

Table1

ID #	Correspondence Name	Submitted By	Submitted On	Due Date	Last Action Taken (LAT)	LAT By
1	ABC	Me	19 Sep	1 Nov	George	23 Oct
3	GHI	Someone	1 Sep	4 Nov	Sam	1 Oct

<TBODY>
</TBODY>

CurUser = George

Table1

ID #	Correspondence name	Submitted By	Submitted On	Due Date	Last Action Taken (LAT)	Lat By
2	DEF	Billy	20 Oct	25 Oct	Sam	23 Oct

<TBODY>
</TBODY>

 

[Robby19]

If possible, I would like a VBA solution.