Trouble with excel spreadsheet extending past the limit of a works

[Cameron]

I have an instance where there is a Pivot table that extends past the limit
of excel for a sheet. Is there a way to build in a macro that can reconize
this length of data and turncate the extra data over to a second sheet?

Kind of new to macros.