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)
[TABLE="width: 500"]
<TBODY>[TR]
[TD]ID #[/TD]
[TD]Correspondence Name[/TD]
[TD]Submitted By[/TD]
[TD]Submitted On[/TD]
[TD]Due Date[/TD]
[TD]Last Action Taken (LAT)[/TD]
[TD]LAT By[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

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[TABLE="width: 500"]
<TBODY>[TR]
[TD]ID #[/TD]
[TD]Correspondence Name[/TD]
[TD]Submitted By[/TD]
[TD]Submitted On[/TD]
[TD]Due Date[/TD]
[TD]Last Action Taken (LAT)[/TD]
[TD]LAT By[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ABC[/TD]
[TD]Me[/TD]
[TD]19 Sep[/TD]
[TD]1 Nov[/TD]
[TD]George[/TD]
[TD]23 Oct[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]GHI[/TD]
[TD]Someone[/TD]
[TD]1 Sep[/TD]
[TD]4 Nov[/TD]
[TD]Sam[/TD]
[TD]1 Oct[/TD]
[/TR]
</TBODY>[/TABLE]

CurUser = George

Table1
[TABLE="width: 500"]
<TBODY>[TR]
[TD]ID #[/TD]
[TD]Correspondence name[/TD]
[TD]Submitted By[/TD]
[TD]Submitted On[/TD]
[TD]Due Date[/TD]
[TD]Last Action Taken (LAT)[/TD]
[TD]Lat By[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]DEF[/TD]
[TD]Billy[/TD]
[TD]20 Oct[/TD]
[TD]25 Oct[/TD]
[TD]Sam[/TD]
[TD]23 Oct[/TD]
[/TR]
</TBODY>[/TABLE]

 

[Robby19]

If possible, I would like a VBA solution.